Thank you sir! I've done that and it does show the higher than expected CPU usage. I'm adjusting the domain service accounts each instance uses to narrow down...

Thanks to everyone for your input. Good information all!

Andrew, I asked about 80 compatibility mode as I have been unable to get a definitive answer on whether one of...

No, we have a mail relay and that is the ip address I specified in the Mail Profile. It is hitting that server and the log there is what...

I was on a phone interview and was discussing certs and I said I wanted my MCITP and the interview said that was not all of them for SQL Server...

Updated stats and rebuilt indexes. I'm making a few adjustments to see if it improves and will check the query plans as you suggested.

Right, I did that and it didnt help. Take a look at the counter for Target Server Memory, The way I understand that counter, its the amount of memory...

I hope you make a lot of money, as long as it remains free for us poor DBAs!

'nix

He's my brotha from anotha mutha!

😀

Ok, got it. The default fill factor written into the clustered indexes when originally created was 10% on a PK identity field. Never going to do a...

I dont think I can since the unused space reserved = Data + Index size with very little unused space. Will shrinking even work? Plus the data size...

nope, it was a straight up restore from a running sql 2000 machine. The db is actually a template that is used for different companies and has been in...

DBCC CheckDb comes back clean and as far as I know there are no non ansi joins in the code. The difficutly is that the entire app consists of...

Thanks Adam,

You answered the question well. I had always thought that setting the min and max was a good idea as well but was reading an article by Brad...

Best place to post it as it doesnt warrant its own topic. If I have basic files for my databases (no file groups) and I execute fn_virtualfilesatats() against all...

Way glad I looked at the suggestion forums Steve. I have the same problem and sent an email to the link under contact us (Webmaster@sqlservercentral.com) but got no response....