Browse by Tags

• activity
• blocking
• buffer
• cpu
• cursor
• dirty
• hints
• i/o
• memory
• performance
• server
• sql server
• statistics
• table
• tsql
• usage
• windows

How to monitor transaction activity between the databases?
10 January 08 03:23 AM | SQL Master | 2 Comments   

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

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

SQL Server Cursors usage and performance - cursed
19 June 07 07:34 AM | SQL Master | 1 Comments   

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 say Read More...

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

Using DMVs is it possible to identify whether CPU is hyper-threaded?
29 May 07 06:12 AM | SQL Master | (Comments Off)   

SYS.dm_os_sys_info DMV delivers most important information such as Operating System CPU tick count, hyperthread ratio, physical and virtual memory, as well as the worker and scheduler counts. From the derived values of this DMV if you observe hyperthread_ratio Read More...

Filed under: server, dmv, databases, windows, cpu

How to find dirty buffer pages and clear them - SQL Server
21 May 07 08:22 AM | SQL Master | 0 Comments   

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 )method. Read More...

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