Viewing 15 posts - 4,966 through 4,980 (of 19,560 total)
Sean Lange (3/7/2013)
Lynn Pettis (3/7/2013)
Sean Lange (3/7/2013)
Lynn Pettis (3/6/2013)
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
March 7, 2013 at 9:15 pm
dwain.c (3/6/2013)
Lynn Pettis (3/6/2013)
Well, I've just...
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
March 7, 2013 at 9:13 pm
TravisDBA (3/7/2013)
Dave62 (3/7/2013)
Procrastination and laziness, distractions from a variety of different sources can occur equally in the office or at home. 😉
Agreed, but the propensity for this happening is much...
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
March 7, 2013 at 9:10 pm
Thanks for the question.
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
March 7, 2013 at 3:40 pm
Awesome Idea. Desks on wheels. Too many times moving teams has involved a day of lost work trying to pack it all up and move to the new...
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
March 6, 2013 at 5:51 pm
Lokesh Vij (3/5/2013)
happycat59 (3/5/2013)
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
March 6, 2013 at 4:38 pm
The slowest part of your reports is by far the data retrieval. This means that your tsql to get the data is the biggest impact.
That can boil down to...
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
March 5, 2013 at 12:19 pm
JKSQL (3/5/2013)
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
March 5, 2013 at 11:13 am
Ferb
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
March 5, 2013 at 10:09 am
Is the stored procedure that has many different parameters that could be passed in?
Do you see a lot of changes against the tables the procedure runs against?
What you are describing...
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
March 5, 2013 at 8:47 am
The X lock is coming from an update statement. The update while there is a table lock is not permitting the select to run until that transaction is committed.
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
March 5, 2013 at 8:38 am
paul.knibbs (3/5/2013)
... I'll allow myself to be gobsmacked that such an obvious flaw has made it into three major browsers. Who audits the code for these things?
+1
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
March 5, 2013 at 8:25 am
Thanks for the question.
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
March 5, 2013 at 8:09 am
You mentioned data retrieval and render time, how about processing time?
I am curious to know if any optimizations have been made towards SSRS settings.
How does the data retrieval compare when...
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
March 4, 2013 at 11:43 pm
In addition to what Minaz threw out there, is the server Clustered? If so, verify that the location that the model db was moved to is on a resource...
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
March 4, 2013 at 9:48 pm
Viewing 15 posts - 4,966 through 4,980 (of 19,560 total)