Viewing 15 posts - 17,596 through 17,610 (of 49,552 total)
Google? (Jonathan Kehayias's blog is a good place to start)
Any by archive, I mean query the system health and insert any events you want to keep into an archive table.
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 17, 2012 at 3:57 am
sqlzealot-81 (7/17/2012)
However a small doubt, System_health might also not have those details if the deadlock happened for quite long time. It might be overwritten. Please correct me if am wrong.
Correct,...
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 17, 2012 at 3:44 am
I'm going to assume you don't have foreign keys in place, because if you did SQL would prevent orphaned data. If there are no foreign keys they there's no automatic...
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 17, 2012 at 3:41 am
Don't use 1204 on SQL 2008, it's the old traceflag and it produces very hard to read info. 3605 is not necessary for deadlock at all.
In SQL 2008, you 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
July 17, 2012 at 3:33 am
What is the goal for the partitioning? What are you expecting to achieve?
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 17, 2012 at 3:26 am
sufiyan.sarguroh (7/17/2012)
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 17, 2012 at 3:25 am
b.hedge (7/16/2012)
MAX DOP is 1 and Hyperthreading is off per the vendor recommended settings.
Not sure I like that recommendation....
CPU utilization of the server is around 6 - 10% even during...
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 16, 2012 at 4:27 pm
b.hedge (7/16/2012)
Why do most workers in sys.dm_os_workers show SUSPENDED and none say RUNNABLE?
They're waiting for some resource. Can't tell what without seeing wait types
When you refresh this query it shows...
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 16, 2012 at 3:39 pm
You need to rebuild indexes regularly, not every 6 months. Ola's script will only rebuild what needs rebuilding so avoids the wasted effort of rebuilding indexes that don't need a...
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 16, 2012 at 3:10 pm
What is your goal for partitioning?
If you're talking about table partitioning (partition functions, partition schemes, etc), that's Enterprise only, any database with partitioning will fail to restore to another edition...
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 16, 2012 at 3:04 pm
1) Don't shrink on a regular basis
2) Don't shrink your log to 0, regrowing a log from 0 is an expensive operation. If you absolutely have to shrink, shrink 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 16, 2012 at 3:00 pm
Shut SQL down for the duration.
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 16, 2012 at 11:37 am
sqlfriends (7/16/2012)
Thanks, what does this mean-in the context of the backup you restored?
Exactly that, in the context of the database restored from that backup.
Think about it.
You took backup 1, let's...
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 16, 2012 at 11:36 am
In short because you restored the database. There's no way on earth that the diff could have been based off the second full backup, because in the context of 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 16, 2012 at 10:59 am
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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 16, 2012 at 10:06 am
Viewing 15 posts - 17,596 through 17,610 (of 49,552 total)