Browse by Tags

TSQL to get current executing statements - SQL Server 2005

Published 12 February 8 2:27 PM | SSQA.net

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...

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

SQL Server 2005 TSQL to obtain buffers by object (table, index) in the buffer cache?

Published 1 February 8 6:30 AM | SSQA.net

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...

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

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

Retrieve SessionID and batch information

Published 24 July 7 4:37 AM | SSQA.net

You may be aware using SP_WHO or SP_WHO2 statements you can get information about a session id and statement that is running since good olden days of SQL Server. Within SQL 2005 version you can take help of TSQL: SELECT session_id, text FROM sys.dm_exec_requests...

Filed under: performance, cache, tsql, tables, object_name, forced