Viewing 5 posts - 16 through 20 (of 20 total)
as the solution you asked....only...
you can put below code in your if else condition to avoid that situation
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
WHERE req.command like '%update statistics%'
May 22, 2014 at 12:12 am
if your second DB is standby. you can also refer log shipping or transaction replication as per your current setup
May 22, 2014 at 12:00 am
you can use powershell scripts commands to move all your jobs by a single job on server.
May 21, 2014 at 11:56 pm
if its scan going on your query that means you can further look for indexes to create. plus also update the statistics.
also try tuning adviser recommendation for whatever query you...
May 21, 2014 at 11:53 pm
1. check is it really a full backup?
2. check for compression option in maintenance plan
3. check for table data in last in case of nothing solve the purpose(previous backup after...
May 21, 2014 at 11:50 pm
Viewing 5 posts - 16 through 20 (of 20 total)