Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

mixed_extent_page_count Expand / Collapse
Author
Message
Posted Monday, December 13, 2010 11:43 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 2,213, Visits: 3,005
Comments posted to this topic are about the item mixed_extent_page_count

Thanks.
Post #1034206
Posted Tuesday, December 14, 2010 12:59 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Saturday, June 6, 2015 9:44 PM
Points: 3,450, Visits: 4,408
The bad news is that, according to BOL, "this view is applicable only to the tempdb database".
Post #1034223
Posted Tuesday, December 14, 2010 1:02 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, September 22, 2016 2:39 AM
Points: 15,371, Visits: 13,116
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1034227
Posted Tuesday, December 14, 2010 2:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 5,268, Visits: 6,994
Very good question, thanks.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1034252
Posted Tuesday, December 14, 2010 3:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 4, 2016 1:50 PM
Points: 1,957, Visits: 3,573
vk-kirov (12/14/2010)
The bad news is that, according to BOL, "this view is applicable only to the tempdb database".
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.
Post #1034275
Posted Tuesday, December 14, 2010 7:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Nils Gustav Stråbø (12/14/2010)
vk-kirov (12/14/2010)
The bad news is that, according to BOL, "this view is applicable only to the tempdb database".
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.


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.
Post #1034413
Posted Tuesday, December 14, 2010 10:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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
Post #1034568
Posted Tuesday, December 14, 2010 11:17 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 2,213, Visits: 3,005
Thnx to all for your valuable feedback !! ..

Thanks.
Post #1034899
Posted Wednesday, December 15, 2010 9:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 23, 2016 7:46 AM
Points: 2,904, Visits: 3,646
Thanks, good question. I knew I should have picked dm_db_file_space_usage!

- webrunner


-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1035289
Posted Wednesday, December 15, 2010 3:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, June 30, 2015 9:47 AM
Points: 2,160, Visits: 2,204
Thanks for the question, I learned a couple things.
Post #1035531
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse