A quick tip from Kevin on speeding up transaction log restores using MAXTRANSFERSIZE.
Search Results for: perfmon
New White Paper: SQL Server Extended Events and Notifications
April 25, 2012 by 2 Comments
Download the new, free white paper from Microsoft MVP Jason Strate detailing SQL Server Extended Events and Event Notifications (registration required).
Totally Awesome and Totally Free Training SQL Server Training
February 21, 2011 by 1 Comment
Tons of free training, including our newest video DVDs, featuring
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 [...]
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 [...]
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 [...]
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 [...]
