Mar 15

SQL Server performance tuning using Windows Performance Monitor #Root #By Sayed Ahmed #MS SQL Server #SQL Server Reporting

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 step by step learning (Follow the steps as shown in the left)

http://msdn.microsoft.com/en-us/library/ms187522.aspx

Other Resources:

Which performance counters can you look at on a SQL Server Instance to determine it’s performance and overall health? – https://dba.stackexchange.com/questions/4449/which-performance-counters-can-you-look-at-on-a-sql-server-instance-to-determine

How to troubleshoot SQL Server performance issues – https://support.microsoft.com/kb/298475

From: http://sitestree.com/?p=1439
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting
Tags:
Post Data:2014-08-24 15:48:18
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 (Software/Web/Mobile/Big-Data/Machine Learning) Shop Online: https://www.ShopForSoul.com/ Medium: https://medium.com/@SayedAhmedCanada