paruchuri4 (5/23/2013)
I need to gather the following prod information for a particular environmenta.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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/