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

Gather Storage Information for SQL SERVER Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 9:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 5:03 AM
Points: 7, Visits: 379
How to gather storage information for a particular sql server environment.
Post #1456071
Posted Thursday, May 23, 2013 10:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 13,103, Visits: 11,933
paruchuri4 (5/23/2013)
How to gather storage information for a particular sql server environment.


What information are you looking for? It is very different if you are talking about details of the physical storage or the amount of required storage, or...


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1456082
Posted Thursday, May 23, 2013 10:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 5:03 AM
Points: 7, Visits: 379
I need to gather the following prod information for a particular environment

a. Physical Server Specification ( Storage)

b. SQL Server Configuration (Data Storage Placement, Partition, Data file sizes)
Post #1456090
Posted Thursday, May 23, 2013 10:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 13,103, Visits: 11,933
paruchuri4 (5/23/2013)
I need to gather the following prod information for a particular environment

a. Physical Server Specification ( Storage)

b. SQL Server Configuration (Data Storage Placement, Partition, Data file sizes)


Can't really help you with a. That is your hardware. Now finding where it is being stored is another topic.

You can look at sys.database_files. If you need to know this for all databases you will have to look at this catalog view for each database. That will tell you what files are being used.

**Note** the size column is the number of 8k pages. To determine the actual size of the file in KB just multiply that by 8.



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1456099
Posted Thursday, May 23, 2013 11:28 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: Yesterday @ 12:39 PM
Points: 3,122, Visits: 11,405
This script will give you detailed information about the database files analyzed multiple ways:
Get Server Database File Information
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058


Post #1456126
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse