There's a checkbox underneath the PM text box, to save a copy into sent items. It is unchecked by default.

See what the following counters look like:

under physical disk

Transfers/sec (for each of your drives seperatly)

under process (for SQL at least. Other processes if you think they may be contributing to...

No reoccurence last night. This is probably going to be one of those once-off mysteries that never get solved. Did get a nice perfmon trace over the entire night that...

From management studio? I believe that error comes from the object explorer.

Try SQLCMD (the command line tool) or using management studio, don't connect the object explorer, create a new...

K. Brian Kelley (10/4/2007)

---

It was worth a shot. Running a server side trace is likely to kill you... I have seen that issue when someone was doing a trace, too,...

Anders Pedersen (10/4/2007)

---

How did the admin get in to kill spids if he could not run queries? If he used the DAC I believe there are only a few...

If you can, run the SQLIOSim (of SQLIOStress, can't remember the name) and see what it tells you about the drives.

It's a stress test tool for drives that simulated the...

Not at the time, no.

I've also seen it in those circumstances, but it's fairly unlikely here. 11pm is the beginning of the overnight process run, and there should be no more than 30-50 connections...

If you're working on SQL 2000, please rather post in the SQL 2000 forums. If you post in SQL 2005 forums, people will offer 2005-specific solutions.

I'm not understanding your problem....

In my experience, buffer latch timeouts are often IO related. You may want to check you drive's performance if you get these more than once or twice.

Since you're working with SQL 2005 (or I assume so, based on the forum) don't use text. It's deprecated. Rather use the varchar(max) datatype.

Also, what you're doing is very strange....

Nick Via (10/3/2007)

---

One thing that is odd though, is that there is another table which has the exact same structure and atrributes as the table I used in this example...

Yup 🙂 That'll give you the names of any triggers on the table. Once you have the names, you can use sp_helptext to get the text of the...

Any strange messages in the sql error log? any strange messages in the windows event log?

What's the specs of the server? (memory, cpus)

Have you tried connecting via the DAC when...