Viewing 15 posts - 23,986 through 24,000 (of 49,552 total)
Ninja's_RGR'us (8/23/2011)
Grant Fritchey (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Awesome info.You guys should really get together and write books or talk @ PASS sometimes :hehe:.
Now what could you possibly talk about? :Whistling:
That's a great idea!...
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
August 23, 2011 at 9:03 am
Depends on the error.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
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
August 23, 2011 at 7:41 am
It separates out the system views, functions, procedures etc from the master DB, so if those are changed (in a patch say), the entire resource DB can just be replaced....
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
August 23, 2011 at 7:41 am
It's not.
It's there to make service packs easier to create.
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
August 23, 2011 at 7:32 am
Yeah, SSMS writing bad code again. What's new?
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
August 23, 2011 at 6:37 am
Just bear in mind that you don't know what is wrong. It may be something trivial, it may be something that brings the system down tomorrow.
Got somewhere else you can...
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
August 23, 2011 at 6:36 am
You need to do a checkDB on that. If not on the live DB then on a restored copy. This is not a luxury, nice-to-have, it's something you must do...
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
August 23, 2011 at 6:01 am
What's the message on that error?
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
August 23, 2011 at 5:53 am
Why are you shrinking?
Why are you shrinking as small as possible? Do that and the next thing that will happen is for the log to grow. That'll slow everything down.
p.s....
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
August 23, 2011 at 5:53 am
Shrink does not break the log chain.
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
August 23, 2011 at 5:05 am
colin.Leversuch-Roberts (8/23/2011)
with 200GB of memory I can't believe this is an x32 system?
Where do you see that?
Min and max memory only set the limits for the buffer cache, in Denali...
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
August 23, 2011 at 5:04 am
Ninja's_RGR'us (8/23/2011)
Ok but what makes you take that call? How can you tell that it's not the index that's @ fault to generate the bad plan?
Stats tell the distribution...
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
August 23, 2011 at 4:14 am
However if you do, the entire varchar(max) is duplicated.
There's a more basic issue here. Why is a name column up to 2 billion characters long? Surely a name is on...
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
August 23, 2011 at 3:50 am
They are both IO-bound operations. Hence if they're slow the first place I'd look is at the IO performance and throughput.
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
August 23, 2011 at 3:04 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1163779-391-1.aspx
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
August 23, 2011 at 3:02 am
Viewing 15 posts - 23,986 through 24,000 (of 49,552 total)