mssqlsystemresource.mdf 69 GB in all threee instances

Question

mssqlsystemresource.mdf 69 GB in all threee instances

Welsh Corgi

SSC Guru

Points: 116520
More actions
June 19, 2012 at 1:08 pm

#258198

Why isn't the mssqlsystemresource visible in SSMS?
The mssqlsystemresource.mdf file has gotten very large on all three instances on server.
I wanted to determine how much free space there is.
Also how does it get to be so large and the same size on all instances?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

What can I do with those Databases?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

69GB, really?

What does this query result in?

select *

from sys.dm_os_performance_counters

Where instance_name = 'mssqlsystemresource'

And counter_name = 'Data File(s) Size (KB)'

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

george sibbald SSC Guru Points: 104210 More actions · Answer 3

the mssqlsystemrsource database is a read only database holding system metadata and Microsoft don't want anyone to touch it, it cannot even be backed up via sql, hence it is not visible in SSMS.

I see no way that file could change in size, are you sure you have read it right?

---------------------------------------------------------------------

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

I thought I'd look at the resource database on one of our development servers, it is only 60.5 MB (63,438,848 bytes) in size.

For it to be 69GB seems really strange.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I'm sorry I misread it.

It is MB not GB.:blush:

I have been working a lot of hours and I'm tired and it's only Tuesday.

Thanks for the information!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281344 More actions · Answer 6

Good to hear that it is the proper size after all.

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

Perry Whittle SSC Guru Points: 234064 More actions · Answer 7

Welsh Corgi (6/19/2012)
I'm sorry I misread it.
It is MB not GB.:blush:
I have been working a lot of hours and I'm tired and it's only Tuesday.
Thanks for the information!

🙂 it's even worse when file sizes are specified in bytes. the amount of times i've converted from bytes to MB or Gb and missed a digit off due to a misread :hehe:

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉