Do you have primary keys (clustered index) on guids? (uniqueidentifier default to NewID())

I normally call them direct, but then I work for a MS premier customer.

Google gave me the following kb article that should get you started. It will cost you something...

Also, during those slow times, query sysprocesses and look for what the wait times and last wait types are.

Not that I'm aware of.

The power of the machine won't affect the results of the tuning advisor. Only the volumnes of data and the workload trace affect that.

The SQL versions...

Does the poor performance occur at regular intervals or times?

Best thing would be to run profiler and perfmon during one of the slow periods. The profiler events you want are...

I think this may be worth opening a case with Microsoft's customer support services. It sounds like you've run into some form of bug.

But the server in question is running production exchange and file server?

Do you not have a development server somewhere?

I would strongly recommend that you run the tuning advisor against a copy of your production databse, not your production database itself.

Take a profile of the prod server to serve...

Why do you want to shrink the log?

If you bring the database online, you will not be able to restore more log backups.

No replies to this thread please. direct replies to:

http://www.sqlservercentral.com/Forums/Topic526415-24-1.aspx

Do you perhaps know what patches were installed?

Is there any possibility of uninstalling the updates one at a time until you find the offending one?

Depends. Is your database in full recovery mode? Do you have log backups scheduled? Are they running?

Do you have transactional replication?

Did anything change on the server between when the backups worked and now? Did you restore any databases, attach any databases, do anything with msdb?

Can you take a look in...

Tune the transaction log? I don't fully understand what you're asking?

Are you trying to clear out space in it?

Books online has a lot of info about the sp_trace procs.

You can also use profiler to generate a script for you. Set up a trace with the events and...