No problem.

Just to show you the kind of behaviour that you might see, I've uploaded an image of a report showing the behaviour of our SQL Server instance when we...

rhunt (10/8/2009)

---

Thanks. I'm actually not at all familiar with VAS fragmentation so I'll have to research the topic in general. Thanks for the tip. Answers to some...

Jeff Moden (10/8/2009)

---

Chris,

How did you determine that sp_OA* was actually producing memory leaks? This isn't a challenge... I'd really like to know because I've said such a thing to...

Just to check the obvious - have you rebooted the server since removing the /3GB switch?

Thinking back there was actually another occasion when we experienced a similar problem with elevated...

We had a similar problem last year with CPU usage - when the CPU usage was high we found that Windows would randomly complain of 'insufficient resources' when performing simple...

Before creating any new indexes you may wish to consider updating the statistics on the tables involved in the troublesome queries:

http://msdn.microsoft.com/en-us/library/ms187348.aspx

If this doesn't have the desired effect then...

I appeciate that you managed to get this to work, but to save time would it be feasible to drop then re-add the column containing the BLOB data? I've used...

I'm at a loss as to why others are suggesting that the log should be manually truncated, particularly as tempdb is in 'simple' mode and, therefore, should be truncated automatically...

Here's a link to a page containing details on how to identify tempdb contention, along with the suggestion of creating one data file per CPU:

http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/11/tempdb-monitoring-and-troubleshooting-allocation-bottleneck.aspx

Cheers

Chris

Hi David

I don't have an explanation for you, but, if you haven't done so already, it might be worth examining the values of the Database Mirroring performance counters:

http://msdn.microsoft.com/en-us/library/ms189931.aspx

I...

Mark Jones (9/4/2009)

---

Good solution, but in a world of non perfect trusted domains the linked server solution simply has too many issues to be viabale. Because you only open a...

I wrote the following sp_block stored procedure to display blocking processes and the processes that they block. I add the stored procedure to the master database of all new SQL...

Before going to the trouble of implementing this solution in SQL Server 2005 onwards, I would first invite you to take a look at the documentation on Database Mail to...

I disagree with point 7 - regarding the sp_ prefix, try the example below.

CREATE DATABASE Test

GO

USE [master]

GO

CREATE PROCEDURE dbo.sp_TempProc

AS

SELECT 'master'

GO

USE [Test]

GO

CREATE PROCEDURE dbo.sp_TempProc

AS

SELECT 'test'

GO

USE [Test]

GO

EXEC sp_TempProc

GO

USE [master]

GO

EXEC sp_TempProc

GO

Chris

You should consider writing your own code for looping through each of the databases as sp_MSForEachDB is UNDOCUMENTED and, therefore, susceptible to changes, or even removal in future releases of...