Monitoring SQL Server FAQ
Following are some of the common questions asked by DBAs about monitoring SQL Server:
| Q1: | How do I know if the bottlenecks I'm seeing in System Monitor are reasonable? |
| A1: | Experience will help here. It is important to monitor the server during normal performance to know what the range of expected values are so that when performance begins to become abnormal, you know which counters are responsible for the change. |
| Q2: | Does SQL Server Profiler slow down the server? |
| A2: | The answer depends on the complexity of the trace and the number of traces running concurrently. When running several complex traces, you might notice a slowdown. Therefore, you might want to limit the amount of information being traced or run individual traces ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
