Viewing 15 posts - 18,961 through 18,975 (of 49,552 total)
The only thing you're cutting out is the write to disk. SQL hands the full backup buffer to the OS and says 'write this to the specified file please' and...
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
April 19, 2012 at 3:06 pm
Sean Lange (4/19/2012)
GilaMonster (4/19/2012)
Just walk away. He's not likely to get it and all you're doing is getting frustrated. Walk away and leave him.
Maybe if we rough him up a...
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
April 19, 2012 at 2:51 pm
matt.newman (4/19/2012)
IDs are identities and keys. No, they will never be zero. Most are seeded identities. Same, seeded identifier PKEY.
Then why are there multiple filters for <some table>ID > 0?...
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
April 19, 2012 at 2:50 pm
Just walk away. He's not likely to get it and all you're doing is getting frustrated. Walk away and leave him.
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
April 19, 2012 at 2:00 pm
Probably a simple query of sys.dm_db_index_physical_stats joined to sys.tables with the page count used to compute the index size. Easiest way to be sure would be to ask the person...
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
April 19, 2012 at 1:55 pm
It's a sort page, so temporarily allocated for a sort operation, probably an index rebuild, and deallocated afterwards. Hence by the time CheckDB ran, the page had long since been...
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
April 19, 2012 at 1:54 pm
Suggestions:
Split the query into two. You've got a union all in the middle, break the query there and do two inserts. Preferably into a temp table not a table variable...
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
April 19, 2012 at 1:47 pm
opc.three (4/19/2012)
You can retrieve the actual plan for your session, check out this article for next time:
That gets an estimated...
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
April 19, 2012 at 1:05 pm
Ok, first thing. Lose the nolocks. http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
Can you post the entire query? There's a fragment in the plan, but it's just a fragment and I suspect a part of the...
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
April 19, 2012 at 12:58 pm
matt.newman (4/19/2012)
Oddly (to me) that was the plan from cache, from production, after running:
A plan from cache is a plan without run-time information, ie an estimated plan. Plans in cache...
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
April 19, 2012 at 12:52 pm
Sorry to be picky, but could you post the actual plan please, not the estimated?
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
April 19, 2012 at 12:00 pm
So data loss of up to a full day is acceptable, but a hot standby server is needed in case of a disaster? As I said, that's a very weird...
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
April 19, 2012 at 10:02 am
Disaster recover and simple recovery model don't usually go together...
Up to a day's data loss is acceptable but the server needs a hot standby in case of a disaster?...
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
April 19, 2012 at 9:50 am
No, no, no, please don't paste XML. That would be horrid to try and deal with here. I'm personally not keen on reading exec plans raw.
Save the plan as a...
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
April 19, 2012 at 8:59 am
Perry Whittle (4/19/2012)
Your best bet might be to use sp_change_users_login.
Except that he'd have to fail the mirroring over to run that, and that could affect the users on the...
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
April 19, 2012 at 7:55 am
Viewing 15 posts - 18,961 through 18,975 (of 49,552 total)