That even better i like that idea...........gosh how to become a nasty DBA overnight.

Im about to turn this on myself for 15 minutes log backups and also have replication on.

The log read is a job that runs in SQL under the jobs you...

A. Bring all the resources of the SQL Server Group in the cluster offline (except for Disk drive and IP Address).

B. go to command prompt and start sql server using...

In Excel 2007 you can link directly to the SQL also.

Click on Data Connections.

Click on properties and set up your defintion.....

Viola no export - direct access ....to SQL.

Good idea on select * in the filtering on the profiler...............awesome then when it fires off

send out an email every 5 minutes to the users.....after 1000 emails do not...

The only way i suggest is to set up ROLES on all databases

DatabaseA

ROLEA (Then give data tables to this role).

Only people in WINDOWS/NT Group will have...

You do not need another tool - follow advice above its all there in SSMS.

Hmm i wonder if the procedures are just not finishing.

Have you put in some dates and times inside of the procedures - are these in house or vendor sp.

The duration...

The SQL Server got shutdown - Check the logs in windows to see what time it got shutdown and by whom.

Servers don't usually shutdown on their own but hey i...

Start with basic - what is my daily growth on my databases that i have.

Monitor this daily and determine what databases grew over the day.

If you have 10...

There some large durations here

exec PaymentFrequencyGetAll

and forsa2000000

exec [c3sabc]..sp_procedure_params_rowset N'ContactNumberUpdate',1,NULL,NULL

exec [c3vvm]..sp_procedure_params_rowset N'DebtorDetailGet',1,NULL,NULLC3C3User24443056

This seems like it taking forever to get the data from the SAN to me..............

Has anyone ran a fragmentation on...

I would put the profiler on around the time and write this to a table and see what is happening at the exact time.

Is the SQL going down or just...

That seems correct - when they login they probrably cannot do anything if you click on databases though.

Thanks for your advice greatly appreciated.

Yes after reviewing the 1500 tables - there are 800 empty tables - and 380 or so static that gets be down to around ...

Update statistics with sample 25 percent.

Optimizer will only use 10% at even given rate is that correct theory.

Anyone got a update statistics script that writes to a table to say...