July 29, 2013 at 6:39 am
Hi.
Log shipping setup on of the table total Records count 1228976 in standby database, user have read access and using reporting purpose...
Particulare query executing 45 mints, what could be reason in standby database?
So, need to be check primary database for statistices , index rebuild if required?
thanks
ananda
July 29, 2013 at 7:22 am
The performance of a query on your standby logshipped destination database should be exactly same as the source providing the servers are of an identicle specification.
Have you looked at the execution plan of the users query? Is it possible there query is badly constructed?
MCITP SQL 2005, MCSA SQL 2012
July 30, 2013 at 8:05 am
I would not assume they're identical in all respects. You need to identify specifically why the query is running slowly. I'd start with sys.dm_exec_requests. That will show you if the query is blocked by another process. It will also show you what resource the query is currently waiting on if it's simply waiting.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2013 at 10:53 pm
Thank you for valuable reply..
In this situation, what will happend Logshipping in standby database..
still continuous apply the log or wait that query execution completion then next log will be applied in standby database?
August 1, 2013 at 8:23 am
ananda.murugesan (7/30/2013)
Thank you for valuable reply..In this situation, what will happend Logshipping in standby database..
still continuous apply the log or wait that query execution completion then next log will be applied in standby database?
The logs are restored based on the schedule that was implemented during setup, what settings did you use for the t-log restore job?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply