My top 3 procedure were this, do you think it is causing my server disc read/write high usage?

1. sp_executsql

2. proc_DeleteEventReceiver

3. msdb.dbo.sp_sqlagent_log_jobhistory

Regards,

Chungb

If i unable to import the trace file into SQL Management Studio because one of the column "TextData" is too big compare with my column in table "TraceResult" , and...

Hi Gail,

I am doing fine with the part 1 to capture the queries and store procedure, i already have the procedure Name ( i use a test database to...

Hi Guys,

I run a few query on my SQL server, and found out everyday at certain time, my server CPU usage will raise up until 100% and that is where...

Ok, thanks a lot.

My SAN admin say nothing wrong with the thing so i will go thru the troubleshooting for my SQL server.

Thanks for the link.

So how to check the IO is overloaded?

My drive is from SAN so mostly it is not the drive issue, but most likely my query. Any query that i...