Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Resource database is read-only
Add to briefcase

Resource database is read-only Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Golfer22
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, February 02, 2013 11:13 PM
Points: 82, Visits: 76
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
Bhuvnesh
Posted Wednesday, December 26, 2012 12:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451
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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #1400166
Bhuvnesh
Posted Wednesday, December 26, 2012 12:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451
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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #1400167
GilaMonster
Posted Wednesday, December 26, 2012 1:07 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.