Viewing 15 posts - 2,611 through 2,625 (of 19,560 total)
Ed Wagner (7/18/2014)
sing4you (7/18/2014)
Ed Wagner (7/18/2014)
fho 21275 (7/18/2014)
BWFC (7/18/2014)
Mulepirate
Scimitar
saber
Sword
swash
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
July 18, 2014 at 7:42 am
Based on all of this, can you provide DDL and DML that would reproduce the issue? Since the issue occurs when running the stored proc alone, there is no...
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
July 18, 2014 at 7:40 am
Jeff Moden (7/17/2014)
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
July 18, 2014 at 7:35 am
What does the inner FOR EACH LOOP container do? How is it configured?
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
July 17, 2014 at 9:49 am
Is there something else other than a select statement in that proc? Trying to gauge if nolock is used in the proc at all.
And back to Jacks question about...
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
July 17, 2014 at 9:31 am
PHYData DBA (7/17/2014)
Then after showing them some information from Paul Randal, and from some Issues with a WellPoint Datawarehouse.
They asked us...
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
July 17, 2014 at 9:06 am
Jack Corbett (7/17/2014)
Sean Lange (7/17/2014)
Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for me...
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
July 17, 2014 at 9:03 am
Ed Wagner (7/17/2014)
BWFC (7/17/2014)
HelixDNA
rNA
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
July 17, 2014 at 8:57 am
Sean Lange (7/17/2014)
SQLRNNR (7/17/2014)
Sean Lange (7/17/2014)
I assume that Summit will be in Bellevue or Redmond. That makes for a length bus trip. Depending on how you hit the timing it...
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
July 17, 2014 at 8:54 am
A good response for this vendor would be to Smile and Wave.
No need changing a setting when it likely won't improve anything. Not under the described circumstances.
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
July 17, 2014 at 8:51 am
Try this article
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
July 17, 2014 at 8:49 am
Are you by chance using NOLOCK in your stored procedure?
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
July 17, 2014 at 8:47 am
That's great for the vendor. But that is an apples to oranges comparison coming from them.
Is the workload high OLTP? Or do you have you noticed parallelism being...
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
July 17, 2014 at 8:42 am
domenico.delbrocco (7/17/2014)
a basic concept but it worth to be rememberedThanks
+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
July 17, 2014 at 8:36 am
Sean Lange (7/17/2014)
I assume that Summit will be in Bellevue or Redmond. That makes for a length bus trip. Depending on how you hit the timing it could be an...
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
July 17, 2014 at 8:31 am
Viewing 15 posts - 2,611 through 2,625 (of 19,560 total)