Thanks for your reply Grant..

I ran the below query while the stored proc is executing:

select w.session_id,

w.wait_duration_ms,

w.wait_type,

...

And also I want that ,eventhough anyone shrink the log file and the datafile it don't reduce its size because of this I am thinking of the resotre.

Thanks

Thanks for your reply pradeep.

It will work for t-log but how to change the size of the datafile which was previously set to default value. I want to set to...

Its not the problem with the edition or version because I am backing up and restoring the database in to the same server.

@@version--Its the same version(2008)

@@autogrow-- Now the database has autogrowth enabled but the initial size was to small sizes due to which it goes on autogrowing which leads to fragmentation.. To...

Thanks Jeffrey and pradeep for your replies

Can any one please help me on this..

Thanks,

Vamsy

Check : select name,log_reuse_wait_desc from sys.databases

Check on which your database is waiting?

Vamsy

Thaks for your reply Gail..

Please help me on this.

Thanks,

Vamsy

Thanks for your suggestions:

Is this the way of predicting how much IOs do I need? Collecting avg disk reads/sec and avg disk writes/sec using perfmon

Thanks,

Vamsy

Any one please help me on this..........

Thanks for your reply....

Based up on above results how I can make a decision:

Which files I have to place on this drive to get high performance benefit and please explain...

No one had stopped the sqlserver service . All of our sqlserver services are stopping with message "sqlserver is terminating due to stop request from service control manager". We are...

There is no other messages related to why these sqlserver,sqlserver agent and msdtc had stopped in error and event logs. In event logs only the following message is there

"...