SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • A quick and dirty WTF???!!!11one

    You can use this to get a quick and dirty picture of what is going on with the server. We basically grab a snapshot, wait a second and then get a diff. Sort as needed. select r . cpu_time , r . logical_reads , r . session_id into #temp from sys.dm_exec_requests as r waitfor delay '00:00:01' select substring...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Dec 7 2007
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems