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