SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Sourav Mukherjee / mixed_extent_page_count / Latest Posts

RE: mixed_extent_page_count

Paul White — Sat, 18 Dec 2010 06:30:21 GMT

[quote][b]SanDroid (12/14/2010)[/b][hr][quote][b]Nils Gustav Stråbø (12/14/2010)[/b][hr][quote][b]vk-kirov (12/14/2010)[/b][hr]The bad news is that, according to BOL, "this view is applicable only to the tempdb database".[/quote]I would not expect much change in SGAM pages in a normal database. Table creation rates should be low compared to tempdb, so frequent changes in SGAM page allocation is unusual.[/quote]I believe this is more important to monitor when you are using Mirroing or Publishing a VLDB.Also it may be usefull you execute large querries (5K+ rows) that use TEMP tables or Table Parameters that have to create objects to store data in TEMPdB.[/quote]No, Nils is quite correct.I have no idea why you think mirroring, or publishing a large database would be a prime factor in tempdb SGAM contention.Where does your magic figure of 5K+ rows come from, or are you just guessing?

RE: mixed_extent_page_count

Nils Gustav Stråbø — Thu, 16 Dec 2010 23:50:28 GMT

I had to do the same (look i BOL), but I don't consider that cheating. "Cheating" in my opinion is when you copy/paste/run the T-SQL and post the answer without utilizing a single neuron in the central nervous system.

RE: mixed_extent_page_count

L' Eomot Inversé — Thu, 16 Dec 2010 18:45:38 GMT

Thanks for teh question. It made me look in BoL, which some say is cheating (and I say is learning).

RE: mixed_extent_page_count

UMG Developer — Wed, 15 Dec 2010 15:28:25 GMT

Thanks for the question, I learned a couple things. :-)

RE: mixed_extent_page_count

webrunner — Wed, 15 Dec 2010 09:58:33 GMT

Thanks, good question. I knew I should have picked dm_db_file_space_usage!- webrunner

RE: mixed_extent_page_count

SQL-DBA-01 — Tue, 14 Dec 2010 23:17:47 GMT

Thnx to all for your valuable feedback !! .. :-)

RE: mixed_extent_page_count

SQLRNNR — Tue, 14 Dec 2010 10:24:05 GMT

Thanks for the question.

RE: mixed_extent_page_count

SanDroid — Tue, 14 Dec 2010 07:34:51 GMT

[quote][b]Nils Gustav Stråbø (12/14/2010)[/b][hr][quote][b]vk-kirov (12/14/2010)[/b][hr]The bad news is that, according to BOL, "this view is applicable only to the tempdb database".[/quote]I would not expect much change in SGAM pages in a normal database. Table creation rates should be low compared to tempdb, so frequent changes in SGAM page allocation is unusual.[/quote]I believe this is more important to monitor when you are using Mirroing or Publishing a VLDB.Also it may be usefull you execute large querries (5K+ rows) that use TEMP tables or Table Parameters that have to create objects to store data in TEMPdB.

RE: mixed_extent_page_count

Nils Gustav Stråbø — Tue, 14 Dec 2010 03:51:16 GMT

[quote][b]vk-kirov (12/14/2010)[/b][hr]The bad news is that, according to BOL, "this view is applicable only to the tempdb database".[/quote]I would not expect much change in SGAM pages in a normal database. Table creation rates should be low compared to tempdb, so frequent changes in SGAM page allocation is unusual.

RE: mixed_extent_page_count

Stewart "Arturius" Campbell — Tue, 14 Dec 2010 02:32:50 GMT

Very good question, thanks.

RE: mixed_extent_page_count

Koen Verbeeck — Tue, 14 Dec 2010 01:02:07 GMT

Very nice question, definately learned something.And thanks to vk-kirov for pointing out an important remark. I hadn't even noticed it when I read the BOL page.

RE: mixed_extent_page_count

vk-kirov — Tue, 14 Dec 2010 00:59:32 GMT

The bad news is that, according to BOL, "this view is applicable only to the tempdb database".

mixed_extent_page_count

SQL-DBA-01 — Mon, 13 Dec 2010 23:43:18 GMT

Comments posted to this topic are about the item [B]mixed_extent_page_count[/B]