Viewing 15 posts - 18,436 through 18,450 (of 49,552 total)
Yes, it is the cause.
The seek is still not an efficient one, if you check the exec plan you'll see a seek predicate and a secondary predicate.
If you can't change...
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
May 25, 2012 at 5:16 am
crazy4sql (5/24/2012)
Should we live our life in bulk logged or full recovery mode?:hehe:
From the article:
Guidelines for Bulk-logged Recovery
The main guideline for bulk-logged recovery is: ‘as short a time as possible’.
Due...
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
May 25, 2012 at 5:11 am
simon4132-806507 (5/24/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
May 24, 2012 at 4:20 am
dave.sexton (5/24/2012)
Just come across this issue - why offer the option in the drop down if it isn't available on the edition you using :angry:
Because management Studio doesn't have an...
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
May 24, 2012 at 3:41 am
It can be worse. It can cause erratic or terrible performance of some queries all the time. Hence the reason I cannot recommend that you use that without doing testing...
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
May 24, 2012 at 3:27 am
michael vessey (5/24/2012)
GilaMonster (5/23/2012)
Index physical stats doesn't run showcontig, more the other way around. Showcontig is deprecated...
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
May 24, 2012 at 2:47 am
It's not the slowdown of the mirroring that you need to test, it's that your workload does not suffer a degradation in performance due to the forced paramerisation.
I would honestly...
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
May 24, 2012 at 2:44 am
There's no script that will get you that information. You can look in the plan cache (sys.dm_exec_query_stats/sys.dm_exec_cached_plans) and some objects will have an entry there. For those that don't,...
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
May 24, 2012 at 2:37 am
I honestly wouldn't recommend turning forced parameterisation on without a lot of analysis of the workload to see if it causes adverse effects. Optimise for ad-hoc workloads is safe 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
May 24, 2012 at 2:34 am
Restore from backup
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
May 24, 2012 at 2:32 am
SQLKnowItAll (5/23/2012)
SQL Kiwi (5/23/2012)
SQLKnowItAll (5/23/2012)
Also note that a unique column can contain 1 null...Unless the unique index is filtered to exclude NULLs 😀
Come on... That's like saying a column 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
May 23, 2012 at 3:25 pm
Perry Whittle (5/23/2012)
according to Paul Randal's post they do both use the same code base but one doesn't actually call the other.
Ok, I thought I'd read somewhere that 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
May 23, 2012 at 2:41 pm
SQLCrazyCertified (5/23/2012)
Hope this helps.....if anyone else want to add/modify what I just said.....please do so.....I am here to learn as well.
Please read the article linked above.
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
May 23, 2012 at 11:49 am
Elliott Whitlow (5/23/2012)
Seriously, the problem in my mind seems to be trying to place blame and that is not something that I really care about.
+100
Time spend trying to assign blame...
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
May 23, 2012 at 11:48 am
Gullimeel (5/23/2012)
Properly designed partitoning will provide you performance definetly.
Not necessarily. Properly done indexing can provide just about the same benefit. Partitioning may give you somewhere around an additional 1% performance...
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
May 23, 2012 at 11:29 am
Viewing 15 posts - 18,436 through 18,450 (of 49,552 total)