There can be possibilities if some of the following are true. (there may be more...

use NETIQ. we use it for monitoring stuff. Also IBM Tivoli is helpful. Or check this:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ServiceStatusMon&referringTitle=AutomatedDBA

Is this Just a single Database or several databases.

Are any of the databases in read_only mode or something.

Are all databases in single compatibility mode and none in 70 or 80.

Are...

you can extend the statement as below for all databases and also create a Table to capture this info on regular intervals.

sp_msforeachdb @command1 = 'USE [?]; SELECT db_name() as dbname,...

This is probably a IO sub system issues. I assume your Database Files and Log Files are all on same disks/Volumes. so the IO on your system is more than...

MS does not support SQL Server under VMWARE.

http://support.microsoft.com/kb/897615

Is this a single login or is the application creating logins at runtime too.. Pl describe how the logins/users are created vias the application.

Right, so this is the trickier part. you can create another table for horizontal partition. At least your regular transactions(inserts/updates/deletes) wont be hurt, and the reporting can continue off another...

Just to be on the same page.

Is this a Static partition - Creating a table for storing historical records based on a range OR a Partition for managing simultaneous...

Here is some more info of your interest.

Query with TEXT and average CPU time for the top five queries.

SELECT TOP 5 total_worker_time/execution_count AS [Avg CPU Time],

SUBSTRING(st.text,...

This issue might arrise, when you have either installed SQL Server tools and sevice pack and top it it you install windows service pack or another hot fixes. you...

The SSIS will throw an Error.

Friend, why dont you Just upgrade to SP3 insted of Individual HotFixes... (I am not sure what that hotfix does/corrects). but SP3 will have everything...

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

your error might be related to a BUG: if i am right.

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/08a9b402-f987-4191-b2f3-0214f6d303fc

LogShipping is the option you should follow, it doesnt matter what the service accounts are.

you Just take care to see that your logs are not heafty in full recovery mode....