SQL Server - guidelines for estimating the space needed for a
database - Feb 27, 2010 at 11:50 AM by Shuchi Gauri
Explain some guidelines for estimating the space needed for a database.
Guidelines for estimating spaces needed for a database:
-
For every table in the database, find an average size that every row would
need.
-
Estimate the size of indexes for every table based on type and number of
indexes. This should include both clustered and unclustered indexes.
-
Consider fill facto and pad index used while creating indexes.
-
Find how many rows can fit into a single 8Kb page.
-
Estimate the size of the heap.
SQL Server - guidelines for estimating the space needed for a
database - May 05, 2009 at 22:00 PM by Rajmeet Ghai
Explain some guidelines for estimating the space needed for a database.
Estimating the space needed for a database is essential to figure out the
performance of the application and size of database. Following guidelines could
help estimating the space:
-
The size of each table in the database should be estimated by calculating the
space required for indexes and heaps.
-
The size of a clustered index can be calculated by calculating the space used
to store data in the leaf level of the clustered index and the space used to
store index information for the clustered index.
-
The size of a non clustered index can be calculated by calculating the space
used to store data in the leaf level of the non clustered index and the space
used to store index information for non leaf of the non clustered index.
SQL Server - guidelines for estimating the space needed for a
database - June 21, 2009 at 09:00 AM by Amit Satpute
Explain some guidelines for estimating the space needed for a database.
Here are some guidelines for estimating the space needed for a database.
-
The size of the tables can be found out by calculating the bytes the rows
occupy. For that tables which do not have a fixed size, their column sizes can
be determined by taking the average from the actual data.
-
Then the type and number of indexes that will be used for each table need to be
estimated. (clustered or non-clustered, the number of indexes, and the width of
the indexes).
-
The Fill-factor and Pad Index used when the indexes are created also need to be
considered. The empty space that these factors affect need to be taken into
consideration.
-
The amount of space taken to store data in a table depends on the number of
rows that can be fit in an 8K SQL Server data page. This could account for the
unused space of the page size in the estimation.
Also read
Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.
Answer - While importing data, the destination table must
already exist......
Answer - Restricting query result means
return of required rows instead of all rows of the table. This helps in
reducing network traffic......
The Master database can be rebuilt using the following steps - The server should
be shut down and Rebuildm.exe should be run..........
Master Database MSDB Database, TEMPDB Database, Model Database.........
|
