Browse by Tags

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.

Published 7 March 8 4:54 AM | SSQA.net

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

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

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Published 17 August 7 8:4 AM | SSQA.net

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

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

Why query execution timeout happens and find queries that have granted memory or waiting on memory?

Published 23 July 7 4:44 AM | SSQA.net

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

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

Handling and troubleshooting memory issues in a SQL Server 2005 instance

Published 19 June 7 4:29 AM | SSQA.net

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

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