September 21, 2011 at 10:18 pm
Hi,
I am using a linked server to query a table in the source server with isolation level as read uncommitted.Log shipping is configured at every 15 mins at the Source server(secondary) from where i am loading the data.I have seen few instances whare while log shipping is on we are fetching only partial data not the full.
please suggest me is any thing i missing in this issue.
Source is on SQL2000
My server is on SQl 2008r2.
Thanks and Regards,
Raja Suri
September 21, 2011 at 11:13 pm
Could you explain a little more what you mean by partial data?
Is it that you are trying to fetch 10 columns and only 9 return?
Or is it that you are expecting 1000 rows but only get 999?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 22, 2011 at 2:52 am
it is expectd to get 1000 rows but fetching only 100 and suceeds
September 22, 2011 at 3:00 am
Log shipping won't cause that. Log shipping is just regular log backups and they don't affect DB activity in any way.
That read uncommitted isolation level however could very well cause exactly what you describe. The isolation level allows for rows to be missed or read twice, and if can happen often if there is concurrent activity.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply