Viewing 15 posts - 30,001 through 30,015 (of 49,552 total)
SwayneBell (10/13/2010)
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 13, 2010 at 6:54 am
scott_lotus (10/13/2010)
1) so you are saying the first column in the index is the important one ? (that makes sense).
No, however the order of columns is critically important.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
3) 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 13, 2010 at 6:49 am
Can you post query, table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
It's hard to give anything other than guesses without.
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 13, 2010 at 6:39 am
Then schedule an 'update statistics ... with full scan' on all tables as soon as possible.
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 13, 2010 at 6:32 am
Brandie Tarvin (10/13/2010)
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 13, 2010 at 6:30 am
Most probably reason is stale statistics. Unless you have a very good reason, turn both auto_create and auto_update on. If you do decide to leave them off, then there MUST...
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 13, 2010 at 5:40 am
ps. (10/13/2010)
Since this was a dev box, even app owners too were not too keen on knowing the root-causes.
Are they aware that without investigating and resolving root cause this could...
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 13, 2010 at 5:07 am
Truncate table is logged in all recovery models. There's no such thing as an unlogged data modification in SQL 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
October 13, 2010 at 4:50 am
hallidayd (10/13/2010)
I suppose if it was me I would concentrate on the lazy writer.
Lazy writer and checkpoint I think. They're about the most relevant of the system processes 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 13, 2010 at 4:27 am
Are you talking about TRUNCATE TABLE?
As i mentioned, there are three different concepts that truncate refers to, please be specific.
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 13, 2010 at 4:10 am
Please clarify your question.
Truncate what? (There are three places at least where that term is used in SQL)
Under what circumstances are you asking. Technically anything can happen if someone runs...
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 13, 2010 at 4:03 am
p.modi (10/13/2010)
thank you for your input as i was not knowing that this topic is so wide.
It's not wide, it's deep.
If you go beyond a list of the background processes...
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 13, 2010 at 3:59 am
SQL server and SQL agent are both cluster-aware services. Jobs are stored in a SQL Server database, in msdb.
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 13, 2010 at 3:53 am
Same as backup strategies for a non-clustered setup. Clustering does not change how, when and why you would back databases up.
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 13, 2010 at 3:15 am
p.modi (10/13/2010)
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 13, 2010 at 3:12 am
Viewing 15 posts - 30,001 through 30,015 (of 49,552 total)