Viewing 15 posts - 11,311 through 11,325 (of 49,552 total)
Yes, stats absolutely matter, and a table scan is not the only option SQL has. It might be able to scan another nonclustered index that has all or some 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
October 12, 2013 at 3:07 pm
Same way stats that are part of an index are used - to give the optimiser an idea of the distribution of the data uniqueness and an estimate of how...
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
October 12, 2013 at 1:05 pm
rodjkidd (10/11/2013)
Gail, I wasn't planning on attending the WIT lunch, but you have me intrigued...
Please do come, even if it's to just laugh and point.
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
October 11, 2013 at 5:35 pm
Jeff Moden (10/11/2013)
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
October 11, 2013 at 5:33 pm
Most likely either the table is a heap or it's too small to bother about defragmenting.
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
October 11, 2013 at 4:02 pm
George M Parker (10/11/2013)
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
October 11, 2013 at 3:56 pm
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
October 11, 2013 at 3:38 pm
Try an outer join, or join to exec_sessions instead. Session space usage is for all current sessions, regardless of whether or not they are currently running queries. exec requests only...
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
October 11, 2013 at 9:36 am
sqlnaive (10/11/2013)
It says that "A transaction log backup contains all the transaction log records generated since the last log backup (or full backup that starts a log backup chain)"
Correct
So in...
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
October 11, 2013 at 9:26 am
Books Online?
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
October 11, 2013 at 6:40 am
sqlnaive (10/11/2013)
So the full backup doesnot impact the chain of t-logs ?
No and never has.
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
October 11, 2013 at 6:31 am
Restore Monday full, Wednesday diff, all log backups from that backup up to the point that you want to restore 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
October 11, 2013 at 6:14 am
I said it's not very useful by itself. So alone it tells you nothing. Along with other counters however it can tell you a lot.
If you have severe memory pressure,...
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
October 11, 2013 at 6:09 am
SQLSACT (10/11/2013)
So, is it safe to say that measuring checkpoint pages/sec is absolutely useless when investigating memory usage and pressure on my SQL Server.
No, it's very useful. It's not...
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
October 11, 2013 at 5:40 am
What, specifically, are the issues?
Buffer pool should fill fast, that's by design (SQL will ramp up buffer pool usage after start up)
SQL will use as much memory as it 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
October 11, 2013 at 4:36 am
Viewing 15 posts - 11,311 through 11,325 (of 49,552 total)