Abstract
For an application code developer, SQL Server essentially is a collection of databases containing tables, indexes, triggers, stored procedures, and views. For a database designer and a person responsible for the performance of the databases, it is required to be able to visualize deeper at the storage structures in SQL Server. A lot of the internals of SQL Server are hidden and undocumented. This chapter explores the storage structures that SQL Server uses and the methods available to visualize them. In specific, a SQL Server refers to a computer containing an installation of the SQL Server software. An SQL Server database is a single database, created within a SQL Server installation. The file types associated with an SQL server include the primary data file, secondary data file, and a log file. Clustering is an advanced architectural structure that allows multiple CPUs to share the same set of underlying data files.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
More From: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.