Is there a tool I can use to map out database physical design like, where the RRSR report server are located, where each database files are? IO bottle neck etcs?
There is no single tool. You need a good DBA. SSMS is the best tool for server & db management.
SQL Server Profiler & Windows PerfMon are the main tools for diagnostics.
Database system & query optimization article:
In a stored procedure, each query must be optimized.
Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?