1
kudos
spam Kudos Remove

Find slowest running queries on SQL Server instance
published 604 days, 22 hours, 52 minutes ago posted by sasa 613 days, 23 hours, 14 minutes ago
Wednesday, September 22, 2010 7:05:59 PM GMT Monday, September 13, 2010 6:43:28 PM GMT
Find slowest running queries on SQL Server instance
If the users are getting what they wanted in time, then no complaints on your day job as DBA. As a best practice you might have few alerts and responses in place to tackle bigger problems to solve, but in case of any performance problem that is not causing any trouble on system and still data is availabel which is classed as slow performance issues. How to solve them? DMV are saviour for DBAs to get all such snapshot information on the system, on the above subject we can take help of DMV sys.dm_exec_query_stats...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: cache, DBA, DMV, execution, Performance, query plan, slow, SQL Server, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup