Browse by Tags

• buffer
• configuration
• cpu
• execution
• indexes
• memory
• queue
• runnable
• sp_who
• table
• tsql

TSQL to get current executing statements - SQL Server 2005
12 February 08 01:27 PM | SQL Master | 4 Comments   

Using SP_WHO or SP_WHO2 is a common way to get list of executing processes currently on the server, within SQL Server 2005 you could take advantage of DMV that lists currently-executing statements. select r.session_id ,status ,substring(qt.text,r.statement_start_offset/2, Read More...

Filed under: tsql, sql server, cache, dmv, execution, sp_who, runnable, queue, cpu

SQL Server 2005 TSQL to obtain buffers by object (table, index) in the buffer cache?
01 February 08 05:30 AM | SQL Master | 2 Comments   

As a programmer interacting with SQL Server's cache is not often needed, but when you do need to determine what is going on with the cache, or you simply need to flush the execution plans or data pages to tune a query, you now have the means to do so. Read More...

Filed under: tsql, sql server, indexes, cache, dmv, memory, buffer, table, configuration