?
Solved

SGAM,GAM doubt

Posted on 2013-01-22
1
Medium Priority
?
194 Views
Last Modified: 2013-01-26
I also read the SGAM,GAM will manage upto 64,000 extents which is 4GB.If there is more than 4 GB of data in the database, will this SGAM,GAM will increase?
0
Comment
1 Comment
 
LVL 15

Accepted Solution

by:
Anuj earned 400 total points
ID: 38809436
Yes, SGAM\GAM can cover only 64,000 or 4 GB of data, as the data increases, new SGAM or GAM pages are added to the file.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question