https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n\n\n","protected":false},"excerpt":{"rendered":"Microsoft SQL Server’s performance can be monitored using the system performance and resource monitoring tool as comes with Windows Operating Systems. With that information, you can tune for optimum performance. I found the following resource to be very useful SQL Server performance tuning using Windows Performance Monitor: http:\/\/www.sqlshack.com\/sql-server-performance-tuning-using-windows-performance-monitor\/ You can check this resource for a … <\/p>\n
Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-22515","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69264,"url":"http:\/\/bangla.sitestree.com\/?p=69264","url_meta":{"origin":22515,"position":0},"title":"SQL Server Database System Tuning #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Database tuning approach Proactive approach Reactive approachBest Approach: Use a mix of both.Be aware (collect information) of the followings that may have significant impact on the performance. Hardware: Server, Available memory, number of processors, disk subsystems. Network Infrastructure: Network Cards, Switches, and the rest of your LAN and WAN. Operating\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4962,"url":"http:\/\/bangla.sitestree.com\/?p=4962","url_meta":{"origin":22515,"position":1},"title":"Introducing Windows Performance and Resource Monitoring Tool, and How that Relates to SQL Server","author":"Sayed","date":"August 24, 2014","format":false,"excerpt":"Introducing the Performance and Resource Monitoring Tool, and How that Relates to SQL Server [youtube http:\/\/www.youtube.com\/watch?v=J2lQmm2o8z8?feature=player_detailpage&w=640&h=360]","rel":"","context":"In "Root"","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22519,"url":"http:\/\/bangla.sitestree.com\/?p=22519","url_meta":{"origin":22515,"position":2},"title":"Introducing Windows Performance and Resource Monitoring Tool, and How that Relates to SQL Server #Root #By Sayed Ahmed #MS SQL Server #SQL Server Reporting","author":"Author-Check- Article-or-Video","date":"March 15, 2021","format":false,"excerpt":"Introducing the Performance and Resource Monitoring Tool, and How that Relates to SQL Server [youtube http:\/\/www.youtube.com\/watch?v=J2lQmm2o8z8?feature=player_detailpage&w=640&h=360] From: http:\/\/sitestree.com\/?p=1444 Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server ReportingTags: Post Data:2014-08-24 19:30:10 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22513,"url":"http:\/\/bangla.sitestree.com\/?p=22513","url_meta":{"origin":22515,"position":3},"title":"SQL Server: Basics of Dynamic Management Views and DBCC Commands #Root #By Sayed Ahmed #MS SQL Server #SQL Server Reporting","author":"Author-Check- Article-or-Video","date":"March 15, 2021","format":false,"excerpt":"Inspired By: Tuning Queries: SQl Server - http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=1156&title=Tuning%20Queries:%20SQl%20Server What are these? Dynamic Management Views, and DBCC Commands Dynamic Management Views: \"Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.\" From: http:\/\/msdn.microsoft.com\/en-us\/library\/ms188754.aspx DBCC Statements:\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7933,"url":"http:\/\/bangla.sitestree.com\/?p=7933","url_meta":{"origin":22515,"position":4},"title":"Introducing the Performance and Resource Monitoring Tool, and How that Relates to SQL Server","author":"Author-Check- Article-or-Video","date":"March 29, 2015","format":false,"excerpt":"Introducing the Performance and Resource Monitoring Tool, and How that Relates to SQL Server [youtube http:\/\/www.youtube.com\/watch?v=J2lQmm2o8z8?feature=player_detailpage&w=640&h=360] \u00a0","rel":"","context":"In "\u09ae\u09be\u0987 \u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 \/MYSQL"","block_context":{"text":"\u09ae\u09be\u0987 \u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 \/MYSQL","link":"http:\/\/bangla.sitestree.com\/?cat=257"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69258,"url":"http:\/\/bangla.sitestree.com\/?p=69258","url_meta":{"origin":22515,"position":5},"title":"Scalability: SQL Server 2005 #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Scalability: SQL Server 2005After you have optimized your database design and the application design, you can improve the scalability of SQL Server in two ways1.Scaling Up2.Scaling OutScaling Up: Improve performance by 1. Adding more processors, memory, and storage capacity2. Replacing existing hardware with faster hardwareNote: You also need the right\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/22515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22515"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/22515\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22515"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}