Hi Boxer,

If you see that Delete statement it uses 2 SQL hints (Updlock and readpast)

meaning is if first SP locks first 100 rows the second SP will...

Hi Larry,

there is a SQL query that can tell you which query is taking lots of CPU utilization

http://www.revenmerchantservices.com/post/2010/04/23/Sql-server-cpu-utilisation.aspx

Thanks, Satalaj.

Hi hrc

The insert operation was performed by Asp.net technology on SERVER A. you suggested that use triggers which means insert on SERVER A should depend on availability of...

yes, I know that query who leads high CPU utilisation.

I had written that query in while loop. It simply deletes top 500 records with UPDlock,READPAST

and insert them into linked...

Hi,

What actions do you perform if it reaches more than 90%. In my scenario, I have multiple SQL jobs which runs in while loop

e.g.

While(1=1)

begin

...

What can I do instead of shrinking big log files which grows rapidely.

In my case log file reaches more than 300GB within 3 to 4 hrs.

To shrink log file I have scheduled a job which executes every 1 hrs.

Is there any...

Is it bad for shrinking log file?

Thanks,Satalaj.