Browse by Tags

How to monitor transaction activity between the databases?

Published 10 January 8 4:23 AM | SSQA.net

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more...

Filed under: sql server, databases, dmv, i/o, tsql, statistics, activity

SQL Server Cursors usage and performance - cursed

Published 19 June 7 9:34 AM | SSQA.net

If you have a requirement to poll through 'n' number of rows then immediately you would think about Cursors in SQL Server. As the solution using any programming language that loops recordsets to build the attendance list that works ok, but really...

Filed under: sql server, performance, databases, dmv, hints, usage, cursor, table

How to find dirty buffer pages and clear them - SQL Server

Published 21 May 7 10:22 AM | SSQA.net

Dirty buffer pages are nothing but consuming more memory for even smaller queries on the SQL Server. By default the DBA shouldn't worry about these dirty pages in the buffer pool as they are taken care by the system using Write Ahead Logging ( WAL...

Filed under: sql server, memory, databases, blocking, dmv, buffer, dirty