I encountered the same thing after installing SQL denali CPT3 on a new virtual server with windows 2008R2

I used this tool to see more

SxsTrace Trace -logfile:SxsTrace.etl => to capture...

great article but I have a question.

I configured a sql instance like mentioned in the article and see all connections coming in with Kerberos auth.

However the connections coming from his...

It try to restart the resource x times, but if it keeps failing it becomes failed.

Great to see this and to know that some one els is also thinking like we do.

We already using single node clusters in our SQL environment now for more than...

it is on the same server, only with less memory on for the sql 2000 and for both instances max degree of parallelisme = 1

I think I find it out

It's Avg Disk sec / transfer . This counter reflects how much time a disk takes to fulfill requests.

Values lower than 0,3 seconds on...

How can I use the mry between 3GB and 4GB for SQL*Server? Or isn't that possible?

Edited by - Ludo Bernaerts on 11/25/2003 06:47:11 AM

You need just one line of code to clear all your user tbles.

exec sp_MSforeachtable 'truncate table ?'

With this I send you the code of a stored procedure + lock info.

As you can see this procedure is started in two different processes and yet they interference with...

It's indeed no problem here, but I generated this as example. The real problem is that other applications using temp. Tables or Mry tables can be blocked too.

Thnx, I will try your suggestions, but keep in mind that this isn't a deadlock but a blocking situation.

A deadlock can take care of it self, a blocking can't.

We have sometimes the same kind of msg on one of our production servers.

Msg:

Could not allocate space for object '(SYSTEM table id: -1016764113)' in database 'TEMPDB' because the 'DEFAULT' filegroup...

I use this one:

select 'grant exec on [' + name + '] to UserName' from sysobjects where xtype = 'P' and status > 0 order by name

This generate a list...