Viewing 15 posts - 45,826 through 45,840 (of 49,552 total)
Shouldn't take that long. I've got a 800 GB database that restores in just over an hour. If it's really slow, check your disk speed and performance
You can restore with...
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
July 9, 2008 at 12:48 pm
DBRindex updates the stats with full scan. What I always advise against is doing a sampled update stats (the default) after a reindex, because the update stats can leave 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
July 9, 2008 at 12:31 pm
Test your backups after you make them. An untested backup is more dangerous than no backup at all.
Make sure you're running log backups if you need to be able 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
July 9, 2008 at 11:47 am
I would suggest calling MS's customer support people. This kind of error is very hard for us to help you with. (details here - http://support.microsoft.com/kb/295539)
Logging a call does cost, but...
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
July 9, 2008 at 11:30 am
Lynn Pettis (7/9/2008)
Oh, should I do that before or after DBCC UPDATEUSAGE? Couldn't remember the DBCC command so I started with updating the statistics.😎
Doesn't matter. All updateusage does is...
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
July 9, 2008 at 10:52 am
This just got posted today. Very useful
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
July 9, 2008 at 10:44 am
Have you done an UPDATE STATISTICS?
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
July 9, 2008 at 10:40 am
gravittl (7/9/2008)
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
July 9, 2008 at 10:30 am
Mani Singh (7/9/2008)
After the Move, Change the compatibility level
Why would you change the compatibility level after moving a database to another server?
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
July 9, 2008 at 10:22 am
Mani Singh (7/9/2008)
sometimes, the Deadlocks might resolve by themselves in time, but if you kill a long waiting deadlock, you might end up with a Phantom Process/lock and...
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
July 9, 2008 at 10:21 am
robin.porter (7/9/2008)
The question was really around 64bit Xeon vs. IA64 Itanium.
Go for the 64bit Xeon. The itanium's not worth the extra hassles that it will cause.
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
July 9, 2008 at 7:07 am
So, what did sysprocesses and the perfmon counters show?
Check this and see if it maybe matches your problem - Memory and SP2[/url]
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
July 9, 2008 at 6:52 am
Jeff Moden (7/9/2008)
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
July 9, 2008 at 6:26 am
Welcome.
First, please read this - http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you can give us your table structure, a sample of the data in it and an indication of the results you want, I'm sue...
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
July 9, 2008 at 5:24 am
I don't know if the x86 quads will beat the itaniums (can you even get x86 quads?) but the x64s could quite easily beat the performance of the Itanium servers,...
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
July 9, 2008 at 5:08 am
Viewing 15 posts - 45,826 through 45,840 (of 49,552 total)