Viewing 15 posts - 19,006 through 19,020 (of 19,560 total)
In addition to the Disk alignment (typically more of an issue on disks formatted by MS OS installs), is to verify the Allocation Unit size (4kb v. 8kb v. 64kb...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 12:07 pm
Gail has provided sound advice. Also consider the additional performance hit (small as it may be) you are experiencing due to the maintenance of those duplicate indexes.
Test your queries...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 11:51 am
Grant Fritchey (11/25/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 11:45 am
It is a nice idea. One problem is that, even though I scroll to the end of the text, or click that I have read it - did I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 11:41 am
The likely reason the DBA does not want to move it is due to hard-coded connection managers to the dev environment. Due to that the DBA is recommending the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 11:35 am
Please attach the actual execution plan.
Are you inserting into an updatable view? IS the query time 4, 16, or 21 seconds, or all of the above?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 10:28 am
try this
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 9:31 am
Thanks Grant for the link. Interesting thread it was.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 9:25 am
To follow up on Gails post, the dropping and recreating of the mirror may not take too much time on a 200MB database - but what about when that database...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 9:25 am
Same info as Atul and Schadenfreude-Mei. Time to extend the database in % gets larger as the growth gets larger which can cause performance issues. To better control...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 8:50 am
Though not in the initial question, I need to ask how you are actually getting the Updates. Is automatic updates configured to receive the updates directly from the website,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 8:39 am
Confio Ignite could also be of use. It is geared towards the different wait types and graphs the longest wait-types that have occurred on the server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 8:34 am
Alvin Ramard (11/25/2009)
CirquedeSQLeil (11/25/2009)
Is that a 73-way tie for first place on a daily basis?
I can't say Jason. I only have ten fingers so these bigs numbers can be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 8:30 am
what methods have you tried so far?
Knowing what you have done will help to focus suggestions and comments.
1 possible solution would be to try a case statement.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 8:29 am
Is that a 73-way tie for first place on a daily basis?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 8:24 am
Viewing 15 posts - 19,006 through 19,020 (of 19,560 total)