We had a similar problem. it's not completely resolved, but it looks like the cursor had an empty record set.

Yea, there is not much out there on sp_getschemalock or sp_releaseschemalock.

I did find some reference to the locks on the schema (BOL) locks sch-m, sch-s if you do a search.

We've found some processes look in the sys.sysservers table. the above mentioned procs do the trick.

you may have to stop and restart the engine, but it most likely can...

DBCC IND

this link was referenced earlier, but if you are looking for info on the DBCC IND command, this one has it.

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/12/13/More-undocumented-fun_3A00_-DBCC-IND_2C00_-DBCC-PAGE_2C00_-and-off_2D00_row-columns.aspx

Thanks for the link !

Thanks, this is a good find for waittype's!

Thanks, but I'm really looking for insight from those who have found ways to capture production traces and use them for performance tuning.

As for the tuning advisor, I've found that...

Love the picture! Tim the toolman Taylor

It all depends. I like to tinker, to understand what makes something work. And I will often do something once, so I understand the key issues to look...

Here are my two cents -

I've been working with SQL Server since version 4.21 (1995), and quite frankly, I have not really seen any issues that would be best...