Viewing 15 posts - 2,746 through 2,760 (of 19,560 total)
Sean Lange (6/27/2014)
Ed Wagner (6/26/2014)
JAZZ Master (6/26/2014)
Ed Wagner (6/26/2014)
SQLRNNR (6/26/2014)
BolaBall
Squirrel
Nut
Zippers
Careful:sick:
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
June 27, 2014 at 7:39 am
Here is a sample http://www.sqlservercentral.com/Forums/Topic1380488-21-1.aspx.
Are your packages stored in msdb or on disk?
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
June 27, 2014 at 7:38 am
Since the move is more political and not performance based, sure go ahead and move the db no matter what the performance is.
That said, to make hardware choices more info...
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
June 27, 2014 at 7:35 am
40% CPU utilization is not enough to get me to get a new SQL Server.
If there are performance issues, I would start looking at other things.
If things are slow, and...
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
June 26, 2014 at 10:06 pm
For the stored procedure part, you can query sys.sql_modules.
To find which packages touch which tables, you would have to parse the xml of each package or look at the package...
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
June 26, 2014 at 5:19 pm
Cody K (6/26/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
June 26, 2014 at 5:07 pm
Love it when they change priorities, not day by day, but minute by minute basis. Makes it a lot of fun to decipher what really needs to be done.
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
June 26, 2014 at 5:00 pm
My point? Most people watch a lot more television than six hours per week. What do I do with that time instead? I read books and blogs. I "tinker" with...
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
June 26, 2014 at 1:19 pm
patrickmcginnis59 10839 (6/26/2014)
SQLRNNR (6/26/2014)
Jeff Moden (6/26/2014)
I think it would be much more fun to partition an IDIOT. 😛With a sliding window?
Should we partition by date? Or something else?
Probably by...
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
June 26, 2014 at 10:37 am
Bola
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
June 26, 2014 at 10:26 am
Jeff Moden (6/26/2014)
I think it would be much more fun to partition an IDIOT. 😛
With a sliding window?
Should we partition by date? Or something else?
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
June 26, 2014 at 9:38 am
KWymore (6/26/2014)
SQLRNNR (6/26/2014)
Jeff Moden (6/26/2014)
KWymore (6/25/2014)
SQL Error: ORA-14451: unsupported feature with temporary table
14451. 00000 - "unsupported feature...
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
June 26, 2014 at 9:10 am
FWIW, looking at your waits, only 2 stand out.
CXPACKET and WRITE_COMPLETION
You can search on those. But without information about IO load or your disk subsystem I won't comment yet...
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
June 26, 2014 at 8:51 am
just making the link look obvious.
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
June 26, 2014 at 8:47 am
Lynn Pettis (6/26/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
June 26, 2014 at 8:42 am
Viewing 15 posts - 2,746 through 2,760 (of 19,560 total)