Viewing 15 posts - 45,481 through 45,495 (of 49,552 total)
Were you testing on the same machine or different? Were the settings of the 2 SQL instances the same?
I can't really offer a suggestion without more info. What did you...
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 24, 2008 at 12:55 am
Always, always set the max memory on 64 bit systems with lots of memory. SQL loves memory and will happily starve the OS if permitted.
I've seen my 48 GB 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 24, 2008 at 12:52 am
Sandy (7/23/2008)
Simon,but how you identify this?....;)
To get out of a while loop, there must be a statement within the loop that sets the variable involved in the while condition 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 24, 2008 at 12:39 am
Same database, same data, same hardware, same queries?
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 24, 2008 at 12:32 am
Pleasure
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 23, 2008 at 12:03 pm
Jeff Moden (7/23/2008)
GilaMonster (7/23/2008)
On my main system, TempDB is 6 files of 8 GB each.
Now THAT sounds like a fun system to be on and that the DBA (you,...
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 23, 2008 at 6:55 am
Jeff Moden (7/23/2008)
Wow... That's amazing, Ross... I haven't heard anything like that in a long time... please tell me those DBA's weren't actually certified...
Depends. Do you mean certified as 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
July 23, 2008 at 6:48 am
It looks like all the errors are in the nonclustered indexes. I would suggest dropping and recreating all of the nonclustered indexes and constraints on the table 'SyncServerState' and recreate...
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 23, 2008 at 6:48 am
Ross McMicken (7/23/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 23, 2008 at 6:43 am
Got a backup?
There are cases where CheckDB cannot repair. They're not common, but they do happen. If you run into that your oprions are usally restore a backup (which 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 23, 2008 at 12:59 am
GSquared (7/22/2008)
With the little you've given, all I can really say is "make sure you have enough drive space".
and more than one independant RAID array.
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 23, 2008 at 12:56 am
Those disk stats don't look good. The sec/write is far too high. Could you plese describe how the disks are set up. How many diska, how many separate arrays, what...
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 23, 2008 at 12:52 am
A full new instance with a different instance name, separate services, etc?
You install SQL again and when it asks for default or named instance, you give it the name 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
July 23, 2008 at 12:48 am
CXPacket is caused by parallel skew, when a process parallels and the part on the one processor runs faster than the other (usually due to having an imbalanced split 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
July 23, 2008 at 12:45 am
This strange thing is that unless you are running in a high isolation level or this select is inside a trigger, a select shouldn't cause a deadlock.
A deadlock requires 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
July 23, 2008 at 12:27 am
Viewing 15 posts - 45,481 through 45,495 (of 49,552 total)