why would you need to do this? the only way would be to RDP to the machine and restart the service

is it the case that the physical size of the ldf file on disk is over 35gb, however after a log backup only a small amount of this file is...

I find activity monitor to be a good overview of what's going on my system. I use whoisactive after that to view the transactions that have been running for a...

Run the following on each instance and compare the output.

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

Also run DBCC TRACESTATUS. There could be a traceflag set on one but...

It depends, if you have no other option, ie applications and other databases will be affected if you don't take action, then you must kill the transaction. As long as...

you need to break that report down to find the query that is causing the long remote server execution.

once you have found the query, run it directly on the...

Yes the spn will fail to register automatically if you are using a domain account for the sql service account and have not explicitly granted it permissions to create SPN....

I can see how this would be ok, because the SQL service effectively restarts in the event of a failover, at which point the tempdb is recreated. So as the...

Are they dedicated sql servers or is anything else running on them that is trying to use a ot of memory? have you tried setting a min memory setting for...

To let you know after running dbccfreeproccache to clear out stale plans Navision performance for the processes mentioned improved dramatically, and sp_execute makes up for a tiny percentage of queries...

Yes worth a go. Thanks for your response

I made a slight mistake, the query is no sp_executesql, it is sys.sp_execute. Is this the same thing?

It would be useful to capture the execution plan when the query is running fast, and capture it again when the query is slow.

Sounds like it is not locking...

Well I have managed to reproduce in my test database, and can see the rebuild of index1 is waiting on LCK_M_IX. The details of the wait resource is a pagelock,...

Thanks GilaMonster, That's what I though, that something was blocking the online rebuild, but on investigation this was not the case. The index rebuild was at the top of the...