Browse Site by Tags

Showing related tags and posts accross the entire site.

FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: On a computer that is running SQL Server 2005...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-25-2007
Filed under: sql server, query, kba, incorrect, multi-processor, running, results
TSQL to detect long running queries against the database

When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id, r.status, r.wait_time,wait_type,r.wait_resource,...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-29-2007
Filed under: sql server, performance, databases, query, tsql, running, long

Page 1 of 1 (2 items)

Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Browse Site by Tags

FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join

TSQL to detect long running queries against the database