Viewing 15 posts - 14,146 through 14,160 (of 19,560 total)
GilaMonster (5/7/2010)
I've added it to my 'list of topics to blog on'. Thanks, the list was getting a little short now that I've finished with in, exists and joins.
That should...
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
May 7, 2010 at 10:57 am
Ahh. I saw the thread asking about good Universities but didn't open it up.
Thanks Gail.
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
May 7, 2010 at 10:55 am
If it is still growing, I am going to re-recommend performing that routine outlined in the article I suggested. There is another query that is causing growth.
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
May 7, 2010 at 10:53 am
Lynn Pettis (5/7/2010)
CirquedeSQLeil (5/7/2010)
GilaMonster (5/7/2010)
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.
Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???)...
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
May 7, 2010 at 10:51 am
Thanks Gail. That explains it quite well.
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
May 7, 2010 at 10:50 am
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
I can see 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
May 7, 2010 at 10:47 am
GilaMonster (5/7/2010)
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
You and 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
May 7, 2010 at 10:33 am
GilaMonster (5/7/2010)
CirquedeSQLeil (5/7/2010)
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
May 7, 2010 at 10:31 am
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
Nah - not rude.
I'm...
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
May 7, 2010 at 10:28 am
Brandie Tarvin (5/7/2010)
CirquedeSQLeil (5/7/2010)
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
May 7, 2010 at 10:24 am
You can also take a look at sys.dm_exec_query_stats. You will need to know the sql_handle for the query you are running though. You would want to look at...
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
May 7, 2010 at 10:21 am
Run this query and post the results
SELECT top 5 *
FROM sys.dm_db_session_space_usage
ORDER BY (user_objects_alloc_page_count +
internal_objects_alloc_page_count) DESC
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
May 7, 2010 at 10:08 am
It seems that this statement is causing a lot of page allocations due to the delete statement. I would certainly take it back to the vendor and ask them...
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
May 7, 2010 at 10:06 am
skjoldtc (5/7/2010)
Here's a link to similar info:
This is the alternate blog site for Pinal Dave. Both link to the same poster for download.
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
May 7, 2010 at 9:58 am
Tom Brown (5/7/2010)
I've had this data for 10 years now, maybe I copied it from someone's SQL 2000 book - or possibly it came from an SQL...
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
May 7, 2010 at 9:51 am
Viewing 15 posts - 14,146 through 14,160 (of 19,560 total)