Viewing 15 posts - 33,661 through 33,675 (of 49,552 total)
SD1999 (3/5/2010)
I think, as per microsoft, Disk Queue length should not exceed 0.02 seconds
Queue measures the number of things waiting. Hence it's an integer value and it's a count of...
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
March 5, 2010 at 1:43 pm
I never said the avg disk queue length was incorrect. It's not. All perfmon counters report accurate, correct values.
The avg queue length is near-impossible to interpret on a SAN....
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
March 5, 2010 at 12:34 pm
Ran across an interesting article while working through my rss reader
http://lifehacker.com/5486247/learning-just-in-case-versus-just-in-time
You can't decide to lean about something when you need it if you don't know it exists, but at 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
March 5, 2010 at 12:12 pm
There's too much between the OS and the disks to get a meaningful threshold for queue length when there's a SAN. It's one of those counter where a value far...
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
March 5, 2010 at 12:09 pm
Robert Biddle (3/5/2010)
Index rebuilds are nightly.
That'll cause the overnight log backups to be large
Other than that, if there's a time of day where they're consistently large, consider running a server-side...
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
March 5, 2010 at 11:46 am
Here you go
http://support.microsoft.com/kb/324270
On Server 2003 RTM, the setting for SynAttackProtect is 0. With SP1 it was changed to 1.
iirc, that's the one that we had to change back 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
March 5, 2010 at 11:17 am
Where did you get the question from?
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
March 5, 2010 at 11:09 am
Transactional replication is the same. Primary key required.
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
March 5, 2010 at 11:08 am
mike 57299 (3/5/2010)
I think the rate would be around $75 per hour. It is negotiable.
I'll be blunt. You aren't likely to get anyone really good for that. I...
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
March 5, 2010 at 11:08 am
I'll look. This was a few years ago though...
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
March 5, 2010 at 11:04 am
Please run DBCC CheckCatalog on the original database (on SQL 2000).
On SQL 2000, checkDB does not run checkcatalog, hence schema corruption (as this appears to be) can go unnoticed for...
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
March 5, 2010 at 11:03 am
Plan caching. The first time you run the query it has to be compiled and an execution plan generated. Subsequent queries used the cached execution plan.
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
March 5, 2010 at 10:59 am
Is this question from the actual exam, or from study material?
If it's from the actual exam, then this is a major violation of the NDA and you should edit that...
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
March 5, 2010 at 10:57 am
Jack Corbett (3/5/2010)
If you are already known as a top-level person (Grant, Gail, etc..), then the cert is unnecessary.
When you're bidding for work (consulting), a collection of qualifications can make...
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
March 5, 2010 at 10:51 am
Robert Biddle (3/5/2010)
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
March 5, 2010 at 10:14 am
Viewing 15 posts - 33,661 through 33,675 (of 49,552 total)