Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource database is read-only Expand / Collapse
Author
Message
Posted Tuesday, December 25, 2012 8:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 28, 2013 5:45 PM
Points: 94, Visits: 96
Even though the resource database is read-only, it is updated by SQL Server, right?

Does sys.dm_db_missing_index_details have information that results in "missing indexes" from ad hoc queries that have been ran once?

sys.dm_db_missing_index_details resides in the resource database, right?
Post #1400128
Posted Wednesday, December 26, 2012 12:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 6:58 AM
Points: 2,834, Visits: 3,949
Golfer22 (12/25/2012)
Even though the resource database is read-only, it is updated by SQL Server, right?
Yes

Golfer22 (12/25/2012)
Does sys.dm_db_missing_index_details have information that results in "missing indexes" from ad hoc queries that have been ran once?
Yes

Golfer22 (12/25/2012)
sys.dm_db_missing_index_details resides in the resource database, right?
Yes

Here is link http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1400166
Posted Wednesday, December 26, 2012 12:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 6:58 AM
Points: 2,834, Visits: 3,949
Golfer22 (12/25/2012)
Does sys.dm_db_missing_index_details have information that results in "missing indexes" from ad hoc queries that have been ran once?
Also check About the Missing Indexes Feature.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1400167
Posted Wednesday, December 26, 2012 1:07 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:27 PM
Points: 42,338, Visits: 35,397
Golfer22 (12/25/2012)
Even though the resource database is read-only, it is updated by SQL Server, right?


No. It contains no data that would require modifying, just the definitions of many of the system objects

Does sys.dm_db_missing_index_details have information that results in "missing indexes" from ad hoc queries that have been ran once?


Maybe. It keeps only a certain number of index suggestions.

sys.dm_db_missing_index_details resides in the resource database, right?


The definition might, the data most certainly does not. It's a DMV which means it's a view into an internal memory structure, it's not data stored in a database on disk.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1400352
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse