I'd suggest using sys.dm_tran_locks instead of the old method. You can get much more granular information and combine the output with other views to get a great deal more information.

Nothing. I'm an idiot. Sorry, I just misread your question.

No, I don't usually see perfmon miss data, but it's possible. How much are you trying to collect and how frequently...

The transaction log can fill from transactions, regardless of the recovery mode, although some recovery modes are less likely to fill the log than others. You need to keep that...

What do you mean by a "forced" database backup?

Call of Cthulhu. It's all a conspiracy. The Elder Gods. He Who Sleeps. The Crawling Chaos. Ia Ia, Cthulhu Fhtagn!

Yeah, I'd pay postage on stuff you want to get rid of as well. Post the list. We'll make claims.

You've got a mixed set of ANSI & non-ANSI joins (some are "tableA, tableB" and some are "TableA JOIN TableB ON"). First thing I'd do is make them all ANSI...

Yeah, Lynn has it right. That's not a good thing. Not only should you do what he said, but I'd review the other eight indexes. See if there are duplications...

I'm not sure if Steve can move just the question or not. Just repost it. However, what I said still applies. Wait states are what will tell you the cause...

Don't just compare query times or CPU load, look at the wait states. What are processes waiting on inside the system. That will tell you where the bottleneck is.

Matt's advice is definitely good.

Here's a local article: http://www.sqlservercentral.com/articles/Administration/performancemonitoringbasiccounters/1348/%5B/url%5D

There are others. Just do a search in the box at the top of the screen.

I don't usually try to plug...

You could run a query using sp_who2 to see who's connected. You can also click on the Activity Monitor icon, which will open the activity monitor and show who's connected.

You...

Gail has explained, at length, many of the behaviors of COUNT(*) over at her blog[/url]. In a nutshell, SQL Server is smart enough to figure out which index, table, statistic,...

Main stream support for 2000 ends in June of next year, 2010. Which, is less than a year away... Yikes!

I'd suspect pretty strongly you're getting blocking. If you have a blocking script, I'd run it (if not search for one in the SSC scripts over on the left), or...