![]() After typing in a name, we can start setting up the counters we want to log. We could theoretically build a single counter log for all of our database servers, but then anytime we want to run the counter log against one of our servers to test its performance, it will log data for ALL servers, and that’s not usually how we want to do performance tuning. Name it with the name of your database server, because each server should have its own log settings. Right-click on Counter Logs and click New Log Settings. One counter log is listed by default, but we’re going to add a new one. ![]() Counter Logs let us pick a set of performance counters and log them to a file periodically. ![]() On the left side, expand Performance Logs and Alerts, and click on Counter Logs. The first thing that comes up is a 1990’s-looking line chart with a few basic performance stats on your workstation itself. On your desktop or laptop (not the SQL Server itself), go into Control Panel, Administrative Tools, Performance. Since every application has its own set of statistics, it helps to get SQL-related tips. As a result, it’s easy to find Perfmon information online, but it’s not always specific to SQL Server. Perfmon isn’t just for SQL Server tuning: system administrators use it to monitor performance on Windows itself, Exchange, file & print servers, and anything else that can run into bottlenecks. After the stats are gathered over a period of time (hours or days), we can do analysis by opening the results in Excel and setting up some basic formulas. The database administrator picks the time interval, file format, and which statistics are monitored. Performance Monitor, or Perfmon, measures performance statistics on a regular interval, and saves those stats in a file. This is performance tuning, and the first place to start is by using Performance Monitor. On any given server, we need to know what the slowest component is, and where it’ll pay off to invest hours and dollars. Database administrators need to know each SQL Server’s weakest link so we know where to focus their hardware budgets and time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |