Viewing 15 posts - 29,581 through 29,595 (of 49,552 total)
MAP - Microsoft assessment and planning toolkit. Free download
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
November 2, 2010 at 11:19 am
I'm chatting with an expert on this, but from the messages in your last post it looks like you have IO subsystem contention - not enough IOPS to handle 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
November 2, 2010 at 11:07 am
Nelson Williams-487553 (11/2/2010)
I find that irresponsible. Here we are on the government created Internet engaging in the free exchange of ideas and you don't want to take part.
The elections...
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
November 2, 2010 at 8:09 am
I'd say just write and submit. It's not as if there are multiple people offering to write it.
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
November 2, 2010 at 7:28 am
Nelson Williams-487553 (11/2/2010)
So, are you going to vote today?
No.
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
November 2, 2010 at 7:03 am
I'll start with two that generally result in things being thrown at me.
knock knock
Who's there
sp_
sp_who?
spid 1, spid 2, spid 3, .....
A SQL query goes into a bar, walks up to...
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
November 2, 2010 at 6:03 am
Please don't post a new thread, I've asked the mod to move this one.
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
November 2, 2010 at 5:45 am
Why are you setting the recovery back to full? You've said this is just a dev/test server and, since you're willing to break the log chains I assume there's no...
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
November 2, 2010 at 5:41 am
vgv8 (11/2/2010)
Do I understand correctly that it is used only for Full Table Scan?
It's one of the allocation pages, it'll be needed for more than just scans. There must be...
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
November 2, 2010 at 5:25 am
Also, don't shrink to 0. Shrink to what you know to be a reasonable size for the databases.
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
November 2, 2010 at 4:05 am
Replication Monitor
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
November 2, 2010 at 3:18 am
ryan.reinaldi (11/2/2010)
GilaMonster (11/2/2010)
Is there supposed to be replication in this DB? Is there an active transactional replication publication?
Yes, this database is a subscriber from another server and also a publisher...
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
November 2, 2010 at 1:57 am
Is there supposed to be replication in this DB? Is there an active transactional replication publication?
What does DBCC OPENTRAN return?
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
November 2, 2010 at 12:04 am
Daniel Britten (11/1/2010)
To be clean I am running DBCC CHECKDB ('database name', noindex) WITH PHYSICAL ONLY.
Bear in mind that those options will miss a lot of errors. You should be...
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
November 1, 2010 at 11:52 pm
pavan_srirangam (11/1/2010)
Dbcc checkdb is checks the integrity of the database why you want to do every 2 weeks
Because it's good to know about corruption while it can still be...
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
November 1, 2010 at 11:50 pm
Viewing 15 posts - 29,581 through 29,595 (of 49,552 total)