Browse by Tags

• 2000
• 2005
• 64 bit
• analysis
• awe
• bad
• blocking
• buffer
• buffers
• cpu
• databases
• dirty
• disks
• execution plan
• long running
• monitoring
• notification
• paging out
• performance
• query
• sql server
• ssms
• troubleshoot
• usage
• verison
• windows
• worker threads

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
07 March 08 03:54 AM | SQL Master | 2 Comments   

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently Read More...

Filed under: performance, sql server, dmv, memory, windows, awe, monitoring, worker threads, 2005, 2000, paging out, 64 bit, verison, buffers

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
17 August 07 06:04 AM | SQL Master | 3 Comments   

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any Read More...

Filed under: ssms, performance, sql server, dmv, memory, cpu, disks, analysis

Why query execution timeout happens and find queries that have granted memory or waiting on memory?
23 July 07 02:44 AM | SQL Master | 1 Comments   

Have you ever identified the reasons for why and how does a query execution timeout happens within your SQL Server environment. For the beginners I would like to explain that b efore executing a query, SQL Server estimates how much memory it needs to Read More...

Filed under: performance, sql server, query, dmv, memory, notification, execution plan, long running, bad

Handling and troubleshooting memory issues in a SQL Server 2005 instance
19 June 07 02:29 AM | SQL Master | 2 Comments   

We had a major issue on one of the SQL Server instance with the memory and getting following error message intermittenlty: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. Eventually I was able Read More...

Filed under: performance, sql server, dmv, memory, troubleshoot, usage

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