"I don't have access to the Prod DB" That's why you need good collaboration with your productiondba. It eases things to get hold on figures smoothly.

"AWE is enabled" so...

you can create your own mysa-account or use your windows-login with granted sqlserver-sysadmin-privileges !

I didn't disable 'sa' with sql2005 up until now, you'd have to test the effect of it,...

I hope this was the first of a series of usefull answers for this year

just my 2ct

- also keep in mind that many of the "technical" sales people even don't know their app runs just fine with a non-sa sqlaccount.

- you can try to...

maybe you could close your sqlserver's tcp/ip port on your firewall if you don't need external connections, just to delimit your perimeter for investigation.

(Default instances of SQL Server use TCP...

- how is the load of other queries in your system ?

- is this a dedicated sqlserver server ?

- 45 % avg cpu is not that alarming, but gives you...

- Which version of sqlserver are you using ??

- With sql2000 you may want to take a look at user defined functions to accomplish this

- with sql2005 a pivot might...

. means local computer.

.\mylogin is windows-userid mylogin at the local computer. It is not a domainaccount.

Likewize with SSMS you can connect to . meaning you want to connect to the local...

- Did you rebuild the indexes ?

- also manualy run dbcc updateusage and sp_updatestats on all your db or at least on the one where you encounter these alerts.

- try...

Check out Data Dude ! Visual Studio Team for DBAs ! Still in CTP, but very valuable for schema-maintenance AND test-data-generation !

with sql2000 you can use

select serverproperty('IsClustered') as IsClustered

Books online document serverproperty !

just as a litle example :

USE

[msdb]

GO

/****** Object: Job [FlipFlop] Script Date: 12/21/2006 09:44:50 ******/

BEGIN

TRANSACTION

DECLARE

@ReturnCode