purushottam2 (1/27/2013)
Above process creates new log file. But CPU utilization is 100 % now.I have rebuild-ed all the indexes and updated stats of tables but still SQL is consuming 100%. I am sure SQL server is consuming 100%.
Have you done Instant File Initialization?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)