Thank this author by sharing:
By Prakash Heda, 2013/06/19
Detect worst performing sql queries which is slowing down Microsoft SQL Server, this script return top queries taxing sql server CPUs.
Applicable to SQL Server 2008 or above.
For detail explanations check this Video.
Rename SQL server Server
Server to server backup
SERVER NAME
VM SERVER
Cloned Server
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com