SQL DBA tip with PerfMon counters in SQL Profiler

To a great technique that can performance problems with SQL Server using both the perfmon and the SQL Profiler together.each of these instruments alone can give you an insight into what is happening on your database server, but in combination can disable, limit your performance bottleneck on a specific event or instructions then focus on the performance problem.

First, is that you must do your perfmon, and then save the results to a file.This, do the performance counters that monitor, by right-clicking and then add trace, then click on the log files tab, and select your Ausgabe.Ich select always. CSV, because it can readily be used for other purposes.

Then should you establish your SQL Profiler trace you want to check. Built-in templates are great for this purpose, select the is most appropriate for the type of problem, try to resolve. Select the option Save to your tracks results to a file, and type, where you want to save the file.

Now, you have both your perfmon, and then click profile set up and ready to go just start them and review, just in case any problems. Once then stop PerfMon and profile has made you place. Open profile backup and the output file from the location you specified, if you track the load profile festgelegt.Nun would you have collected the data, Add PerfMon to do this, click file and then performance Daten.Gehen import, where you the Perfmon log and double darauf.Ein dialog box to select the items show want to select your items, and then click OK.

Now you can chart Perfmon top rail box SQL Profiler in profile.now all you have to do is, click on the chart of the Perfmon where the event occurred, and you will with the editing window automatically on the same point in time.see, for example, if you have been experiencing an increase in CPU activity, select the Perfmon chart to, where you want the CPU peak start, and then the profile Edit window will receive scroll up to the period and, exactly what statements were made in SQL Server at this time.Now you can focus on these statements to improve the performance bottleneck.

PerfMon with SQL Profiler together are a powerful combination that you can use to troubleshoot performance problems in SQL Server.can this technology on a regular basis to our database with highest efficiency.

Go to my SQL DBA website for more information.