The PerfMon Counters That Just Won't Die One of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away. (Some day, politicians will realize this. We can easily fact check their consistency). Because of longevity of content posted to the Internet, a lot of performance tuning topics become "zombies". We shoot 'em in dead, but they keep coming back! In other words, those old recommendations were a suggested best practices for long ago, for a specific version of SQL Server, but are now … [Read more...]
Search Results for: perfmon
Quick Tip – Speed a Slow Restore from the Transaction Log
Here's a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. To do this, you should use the MAXTRANSFERSIZE parameter of the RESTORE statement. For example, if you set MAXTRANSFERSIZE=1048576, it'll use 1MB buffers. If you change the MAXTRANSFERSIZE, keep an eye on the PerfMon objects for Buffer Manager and … [Read more...]
New White Paper: SQL Server Extended Events and Notifications
Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look? As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white … [Read more...]
Totally Awesome and Totally Free Training SQL Server Training
One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world), Don't forget that free DVDs of our virtual conferences featuring me, along with Buck Woody (blog | twitter) and Brent Ozar (blog | twitter) will be mailed anywhere in North America free of charge, now available at this link. Enjoy! -Kevin Twitter at kekline More content at http://KevinEKline.com … [Read more...]
PBBM
Title: Performance Baselining, Benchmarking, and Monitoring Abstract: It's impossible to truly tune a SQL Server without a good understanding of its performance profile and work load. This session describes techniques and procedures to assess the baseline performance profile of a SQL Server, benchmark the performance of the server under varying work loads, and how to continuously monitor the server for maximum availability and performance. The session includes detail demos of how to use the native Microsoft tools to run baseline and benchmark tests. In addition to the main objectives, … [Read more...]
End-to-End Troubleshooting Checklist for Microsoft SQL Server
Title: End-to-End Troubleshooting Checklist for Microsoft SQL Server Level: 200 Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. So strap yourself in to a time machine, because you’ll learn in less than two hours what it took Kevin years to figure out through hands-on troubleshooting and problem solving. This hands-on session … [Read more...]
End-to-End Troubleshooting for SQL Server
End-to-End Troubleshooting for SQL Server Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate: - … [Read more...]