Search Results for: perfmon

The Zombie PerfMon Counter That Never Dies! Quick Tip

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...]

Free Poster – SQL Server PerfMon Counters

You Needs It! You Wants It! We all know how hard troubleshooting SQL Server can be.  There are tools and techniques that can make troubleshooting much easier, such as the Windows System Monitor. The only problem with SysMon, or more commonly "PerfMon", is that it takes a lot of knowledge and experience to know which objects and counters to examine. I've put together a nice poster for you covering all of the important PerfMon counters for SQL Server troubleshooting, with a little help from some of my friends: Brent Ozar, Bob Ward, Christian Bolton, and Raoul Illyes. You Can Has It Fer … [Read more...]

Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

  Join me for a day of Real World Database Configuration and Tuning for Microsoft SQL Server SQL Saturday Silicon Valley 2014 Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT) Mountain View, CA Click HERE to register Now! Seating is very limited!   This full-day training event combines a thorough overview of fundamental architectural concepts of the SQL Server relational engine followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. … [Read more...]

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

Title: End-to-End Troubleshooting for SQL Server Level: 300 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 will take you from … [Read more...]

PBBM – ILL

Title: Performance Baselining, Benchmarking, and Monitoring ILL Abstract: It's impossible to truly tune a SQL Server without a good understanding of its performance profile and work load. This instructor-led lab will interactively teach you the 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.   You will learn how to use the native Microsoft tools to run baseline and benchmark tests. In addition to the main … [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...]