Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Monitor SQL Performace Script

Author  Topic 

petek
Posting Yak Master

192 Posts

Posted - 2010-01-11 : 05:12:14
Hi,

Is there a way to monitor SQL Perfomcance from a T-SQL Script?

i need to monitor top 10 SQL Statements executed and log the information.......

Cheers

pete

Kind Regards

Pete.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-11 : 11:43:15
see this

http://blog.sqlauthority.com/2009/01/23/sql-server-2008-2005-find-longest-running-query-tsql-part-2/
Go to Top of Page
   

- Advertisement -