I don't think SQL Server can restrict the number of sessions for a particular user. You can restrict the total user connections by setting the advanced option user Connections.

Did you change any object ownerships ?

Run the trace from a remote server so that you can take off some load from the server.

Try killing the spid from task manager

When you open the properties for SQL resource, the second tab is for Dependencies. Make sure that the new disk is included under resource dependencies.

Check perfmon counter Transactions/Sec under the object SQL Server Databases. You can specify the database also.

Below is a script which you can schedule locally from within SQL Server  and see if you run into any issues when running locally also.  I ran this script every...

Yes, fragmentation can be a cause. The reads gives you the no. of pages read and this can vary due to the fragmentations. Also try running

set statistics_io on

And check what...

Check this KB article. This is a very common cause for rebuild failing.

http://support.microsoft.com/default.aspx?kbid=273572

Try comparing the execution plans on both servers ? It is possible that production (because of the load) might be taking a slightly different execution plan resulting in the higher...

I agree. my bad.

"This drive had already been assigned to the 1^st virtual server"

I don't understand what you mean by the above.

For Active-Active installation, each instance should have one dedicated disk drive(volume)...

The resource kit has a utility called logparser. You can directly dump data into sql tables using this utility or process the data as you need. You can run this using...

Below is the procedure. We use sp_sendcdosysmail for notification and i have that in the procedure. You can use your own notification process.

create procedure Job_Executing_notify  @job_name varchar(30)

set @job_name = '%DB...

Does both the servers have same amount of free space ?