Viewing 15 posts - 27,526 through 27,540 (of 49,552 total)
Ignore TempDB. Go read Paul's blog post.
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 7, 2011 at 12:50 pm
Certifications never expire, they just become unavailable to write.
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 7, 2011 at 11:57 am
Please note: 3 year old thread.
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 7, 2011 at 11:55 am
Don't use % growths. Gets you into big trouble if there's unexpected growth as the growth size increases as the file size increases. Chose a fixed value that's sensible, large...
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 7, 2011 at 11:50 am
Be specific about the restore error.
As for the VLFs, it's apparent that the log needs to be 36 GB in size to support the maintenance, so shrink it to 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
March 7, 2011 at 10:08 am
Nope. SQL doesn't keep track of when anything runs. You'll need a trace, and it won't be a simple 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
March 7, 2011 at 10:03 am
WOTD - Home.
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 7, 2011 at 9:17 am
When you alter or drop a stored proc, any cached execution plan is immediately invalidated, you don't have to do anything to cause 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 7, 2011 at 6:05 am
Start with Books Online and see if there are any white papers from microsoft
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 7, 2011 at 2:51 am
Please go and do some reading on how SQL uses the data cache.
Writes are also done to the cache and are written to disk later, not written to disk...
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 7, 2011 at 2:35 am
Did you update a column that was part of the index that you're looking at?
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 7, 2011 at 1:22 am
Not directly possible. You'll have to first create a computed column for the year and then index 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 7, 2011 at 1:20 am
chandan_jha18 (3/7/2011)
So even if there is a bad design and inefficient index,my data is still in the memory.
So? The query processor always operates on data in memory. All you avoid...
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 7, 2011 at 1:13 am
vinod.saraswat (3/6/2011)
Can you plz. give the step by step guide.
For what? Between Paul's blog and Grant's reply we've given you several options, none very complex.
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 7, 2011 at 1:10 am
After a shutdown like that SQL has to run crash recovery on all databases. If they were very busy, that can take some time. If you can run checkpoint before...
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, 2011 at 12:41 pm
Viewing 15 posts - 27,526 through 27,540 (of 49,552 total)