55881 seems pretty healthy to me. Are you seeing other symptoms of memory pressure?

Andrew

does this path exist? If not, change it to one that does exist, or create it... 'C:\myfolder\mytrace'

thanks, Andrew

🙂

do you use the SQL Server Audit feature?

Just checking that it's the entire SQL Server restarting, not just the database(s)... as that could be fairly easy to explain away (probably)

Are you able to post the informational messages...

Hi,

Take a look at Jonathon Kehayias' blog post, which might help you out.

http://www.sqlskills.com/blogs/jonathan/post/Finding-what-queries-in-the-plan-cache-use-a-specific-index.aspx

Thanks, Andrew

Here's a very good explanation of Instant File Initialization:

http://sqlblog.com/blogs/tibor_karaszi/archive/2009/03/09/do-you-have-instant-file-initialization.aspx

Hi,

There are many standard reports that will show you where most of the space has accumulated (right click database > Reports > Standard Reports). Disk Usage by Top Tables,...

Hi, thanks for your input. I'd performed the same tests with changing the users default database and connection string and saw the same results. I thought I might...

ha, I wish! There's 3 beefy ones on there, and a couple of tiddlers

there might be a cheeky 256GB in that host 😎

Points taken though... thanks

Ninja's_RGR'us (9/23/2011)

Gonna be slow as hell to run.

Try that code on a...

if all you want is row counts, you could use:

exec sp_MSforeachtable 'select count(*), ''?'' as table_name from ?'

OK - thanks for the advice. This is the only time I've seen one like this - the typical deadlocks we see are much easier to interpret. If...

Hi,

We're already getting the deadlock events written to the log. I've turned on verbose logging for deadlock events, which produced the attached file, but I am unfamiliar with this...