Thanks for that Andy, yes I'm aware of that.

Basically needing to compare price v benefit of splitting them up, and performance is the obvious thing to point at I suppose....

Thanks for that Leo.

How do you configure your logs to 15 and cycle daily?

Do you create a daily job that runs "EXEC master.sys.sp_cycle_errorlog" ?

Thanks for that, really helpful.

Have set MinMemory to 20000 and MaxMemory to 30000

Couldn't you consider using Resource Governor to control what these "power users" can do to stop affecting everything with their users?

Thanks for that Nicholas, very helpful. You're right re 64 OS and SQL.

There will be mirroring occurring, but that's it in terms of advanced features. There will be no...

TECHBABU (2/15/2010)

---

From my experience mostly rely on perfmon tool to observe the counters instead of process monitor 🙂

This would not answer your question but does keep you away from good...

Yes it does, my domain user...

Thanks very much for that, I'll post back with any questions 🙂

This is the query I have running off SQL 2008 with a copy of the SQL 2000 database.

If I run it on SQL 2000 SP3a I get:

Msg 208, Level 16,...

Thanks for that Ron, is there an easier way though to pull this information out as there's over 2000 tables?

Thanks for the response 🙂

If you point it to the Principal, and the Principal goes down, how...

No worries, have used your package to build in lots more WMI events and SQL checks as well 🙂

Awesome package.

Thought I'd offer up a suggestion, if you change the WMI query to:

select FreeSpace, DeviceID, Size, SystemName, Description

from WIn32_LogicalDisk

where DriveType=3

It will check all actual drives, and exclude floppy, CD-ROM,...

Thanks Pradeep, appreciate the help 🙂