HomeНаука и техникаRelated VideosMore From: DBAFundamentals

Identifying Long Running Queries

42 ratings | 12581 views
Tuning the performance of your queries in SQL Server can be a lot of work. However, in order for your systems to receive the full benefits of query tuning, you must tune the queries that need it the most. This session will show you three different methods for determining which of the queries on your system are being called the most frequently, take the longest period of time to run, or are using the most resources. You'll be able to use the information in this session to quickly set up your own metrics gathering processes in order to understand what is happening on your systems and which queries will benefit most from tuning. Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011. Hosted by Steve Cantrell of DBAFundamentals
Html code for embedding videos on your blog
Text Comments (4)
Raju Sri (1 month ago)
Awesome... Can't thank you enough
Jason Clark (6 months ago)
Identifying the cause of long running queries help to improve the performance of SQL query. I found one helpful article which share some quick tips to improve the Query performance: https://www.sqlserverlogexplorer.com/improve-performance-slow-running-sql-server/
Muzammel Haque Mukul (2 years ago)
Really encouraged me to use ex events. Thanks.
tj (2 years ago)
26 + 19 = 45 (not 35) :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.