GilaMonster (3/5/2014)
SQLRNNR (3/5/2014)
GilaMonster (3/5/2014)
Potentially. I haven't tried this because I don't have a 2012 instance available. It's undocumented.
SELECT *FROM sys.dm_db_database_page_allocations(DB_ID('<Database Name>'), NULL, NULL, NULL, 'DETAILED') dpa
WHERE allocated_page_file_id = @FileID AND allocated_page_page_id = @PageID
Should work. I might add database_id to the predicate.
No need, because the first parameter to the function limits the returned resultset to just the DB of interest. It's like index_physical_stats.
Fair point. I ran it and passed the DBName to the parameter. So, dunno what I was thinking.:Whistling:
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