Actually, we've experienced issues with not having the database files not spread out over enough LUNs.  Our managers were convinced that since the EMC does RAID 10, that a...

I have not seen any white paper from Microsoft regarding best practices of a reboot schedule.

In our organization, we only reboot the servers when patches are applied or (rarely) when...

Also, the date/time stamp of the files change when you stop/start your SQL Server (or a reboot occurs). If you have your services configured to auto-restart upon failure, that...

To "uncluster" them, backup up all the DBs, detach the DBs, uninstall the virtual instances, uninstall the default instances, and finally uninstall the cluster service.

If it is your desire to...

Dropping and recreating the indexes may or may not help resolve the allocation errors. It will depend on what is stored on those pages. CHECKDB with the REPAIR_ALLOW_DATA_LOSS...

Have you run a Profiler trace and then ran the Index Tuning wizard against the workload for it's recommendations? There may be several indexes that are not being utilized...

I'd wager that the messages you are referring to are in the NT event logs, most likely the Application event log.

The only method I'm aware of is to have a Profiler trace running against your database and capture the events Database\Data File Auto Grow and Database\Log File Auto Grow.

Using multiple DBs versus a singular DB will affect SQL Server's memory and hence it's performance. I would recommend testing both multiple DBs and a singular DB.

If you're going...

As a5xo3z1 suggested, use float instead of int or use CAST. Personally, I'd use floats like the following:

SET NOCOUNT ON

DECLARE @CPU_Busy AS float,

...

Ack! Posted before I was finished. The SQL Server Agent account should be a member of the local Administrators group for the autorestart function. I've run into to...

Thank you for finding the reference I could not. However, according to the link you provided, the account that SQL Server Agent service operates does need to be a...

I'd also check the memory usage for the SQL instance. Compare it to what was being used before SP3 was applied. I have seen SQL Server start escalating...

My suggestion would be to run a Profile trace and then run that captured workload through the Index Tuning wizard to obtain it's recommendation. That's the most efficient manner...

stevekeily,

You can use fn_trace_getinfo to return just the trace records you want by specifying an appropriate WHERE clause. You could use that in conjunction with bcp to create a...