We've been investigating this.  We can still supply them with a link that will call up a specific letter based on criteria they specify (bookind number, order number, etc).  They...

ARGGGGGGGGGHHHHHHH!!!!!

You are NOT going to believe this, but as a last straw...

ARGGGGGGGGGHHHHHHH!!!!!

You are NOT going to believe this, but as a last straw...

We agree, we wou7ld have anticipated a slow start as everything compiled and then an increase in speed, but that isn't happening.

The hardware spec of the server are:

IIS - Dual...

Slight update, we've solved the deployment of reports problem.  It was down to creating a group on the server and adding all the programmers to it with the correct rights.

What...

Sorted, looks like there was a glitch in the transaction log.  Destroying the tempdb and recreating it has solved the problem.

This is the problem, the log space is showing as being 'used'.

We are watching temporary tables being created and dropped, and the 'used' data size of the tempdb is growing...

A bit more information.

We've isolated part of the problem.

One of our programs uses local temporary tables to help reduce the data sets needed for comparisons.  The system has work efficiently...

Erm, make that 10!

PS, love those helpful messages that have just appeared on the left of the posting window - "Banner turned off...

Many thanks.

Many thanks to NPeeters who set me on the right track. This is one of our problems. We finally tracked down a faulty stored procedure which could lock...

We've already headed down these routes and are still stumped.

The performance monitors are showing that there is a problem in the fact that both CPUs are at 100% and the...

* BLUSH * Big Time!

This is ripe coming from a DBA who still develops, but I'd often looked at the sysprocesses and wondered whether I could get the additional information...

Just a personal note to agree with Allen, running the debugger against a production server is not advisable, and I tend to avoid the debugger at all costs.

Personally I put...

Many thanks for pointing me to the article.

It basically confirms the thoughts and plan that I've been putting together.

My biggest problem is going to be that fact that the IT...