When exactly are you getting this error? Does it always happen?
Which version of Gemini?

we are facing this issue when we migrated from 2.0.3 to 3.6.1 last week.

The new version is giving this error

Which page is throwing the error? What is your database increment settings?

It is happening with multiple pages.Our growth rate is 10%.Same configuration used for 2.0.3 version Database.

Please suggest any relevant solution ASAP

It might be due to data fragmentation issue as 10% might be too small.
I suggest changing it to say 100mb and re-running the upgrade.

Hi,

We have set to 100 MB.But our database size is 1.8 GB. if 10% growth means that would be 180 MB.By setting this 100 MB means did we reduce the space really ?

Please suggest on this.

 

Thanks,

Senthil

 

Ok, how big was the database before the upgrade?

It will be good if you can restore the original 2.x database, set the growth to the actual size of the database (if it is 800mb, set the growth to 800mb) and run the upgrade.

If you still have the timeout issue after that let us know and we will remote in to see if we can spot anything.

Hi,

The actual size was around 1.6 GB before upgrade.Now 200 MB data added and we can't run the upgrade again with the old data.Already production is running.

Can we set it for the live database ?

Thanks,

Senthil

 

So are you running now with the upgraded database?
How often does the tiemout occur? Which version of SQL?
Can specify the pages that are experiencing these issues?

Thank you for your valuable and timely support.

Yes,currently we are running with upgraded database only.

Yesterday there were so many occurences and even users stopped working.

We are using SQL SERVER 2005.

The pages are comment.aspx,issue.aspx and issues listing screen.

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd) "

The above error log is today we received.

Is there any thing to do with connection pooling ?

Please suggest

Thanks in advance.

Senthil

Please try and update the statistics on the geminiissues it might be that it needs to re-index:

update statistics geminiissues with fullscan

Hi,

Tis is was e resul.

DBCC SHOWCONTIG scanning 'geminiissues' table...

Table: 'geminiissues' (1060198827); index ID: 1, database ID: 9

TABLE level scan performed.

- Pages Scanned................................: 7791

- Extents Scanned..............................: 982

- Extent Switches..............................: 1022

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 95.21% [974:1023]

- Logical Scan Fragmentation ..................: 1.49%

- Extent Scan Fragmentation ...................: 56.01%

- Avg. Bytes Free per Page.....................: 1368.9

- Avg. Page Density (full).....................: 83.09%

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Hi,

That was the statistics i got for gemini_issues.

Does it require to run update statistics command ?

Thanks,

Senthil

Yes, please do.

Hi,

 We are facing an issue with time out as below log message. We are facing this issue when we migrated from 2.0.3 to 3.6.1. This is a critical issue please suggest us ASAP

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

Our Data base Information :

SQL server 2005

Space available -583.59 MB

Size of database-18174.69 MB

Gemini Data services-By 500 MB to Unrestricted growth.

Gemini data service log-By 500 MB to Unrestricted growth.

 Thanks in Advance

 Thanks

Vinay and senthil

Hi,

Can you see bellow information also?  update statistics geminiissues with fullscan some extent it will make the application fast. When we export . Yesterday we tried  pull the values(exporting to xl options between some date range) this problem occured. when we create new customfields alos gemini will become slow.

DBCC SHOWCONTIG scanning 'geminiprojectlabels' table...
Table: 'geminiprojectlabels' (36195179); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8042.0
- Avg. Page Density (full).....................: 0.64%
DBCC SHOWCONTIG scanning 'geminiissuealerts' table...
Table: 'geminiissuealerts' (48719226); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 48
- Extents Scanned..............................: 8
- Extent Switches..............................: 7
- Avg. Pages per Extent........................: 6.0
- Scan Density [Best Count:Actual Count].......: 75.00% [6:8]
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 8022.0
- Avg. Page Density (full).....................: 0.89%
DBCC SHOWCONTIG scanning 'customfielddatabkup14072009' table...
Table: 'customfielddatabkup14072009' (55671246); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1448
- Extents Scanned..............................: 182
- Extent Switches..............................: 181
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.45% [181:182]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 58.7
- Avg. Page Density (full).....................: 99.27%
DBCC SHOWCONTIG scanning 'customfielddatabkup1971133' table...
Table: 'customfielddatabkup1971133' (71671303); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 2079.0
- Avg. Page Density (full).....................: 74.31%
DBCC SHOWCONTIG scanning 'geminiprojects' table...
Table: 'geminiprojects' (84195350); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5489.0
- Avg. Page Density (full).....................: 32.18%
DBCC SHOWCONTIG scanning 'projectresource' table...
Table: 'projectresource' (85575343); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 14
- Extents Scanned..............................: 10
- Extent Switches..............................: 9
- Avg. Pages per Extent........................: 1.4
- Scan Density [Best Count:Actual Count].......: 20.00% [2:10]
- Extent Scan Fragmentation ...................: 90.00%
- Avg. Bytes Free per Page.....................: 3105.3
- Avg. Page Density (full).....................: 61.63%
DBCC SHOWCONTIG scanning 'DBDchangdIssue' table...
Table: 'DBDchangdIssue' (87671360); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7114.0
- Avg. Page Density (full).....................: 12.11%
DBCC SHOWCONTIG scanning 'geminiissuevotes' table...
Table: 'geminiissuevotes' (93243387); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7940.0
- Avg. Page Density (full).....................: 1.90%
DBCC SHOWCONTIG scanning 'customfielddatabkup140720092pm' table...
Table: 'customfielddatabkup140720092pm' (103671417); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1448
- Extents Scanned..............................: 182
- Extent Switches..............................: 181
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.45% [181:182]
- Extent Scan Fragmentation ...................: 1.10%
- Avg. Bytes Free per Page.....................: 58.7
- Avg. Page Density (full).....................: 99.27%
DBCC SHOWCONTIG scanning 'geminiissuelinktypes' table...
Table: 'geminiissuelinktypes' (112719454); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7702.0
- Avg. Page Density (full).....................: 4.84%
DBCC SHOWCONTIG scanning 'issuevotes' table...
Table: 'issuevotes' (119671474); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'versions' table...
Table: 'versions' (133575514); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.3
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 5348.0
- Avg. Page Density (full).....................: 33.93%
DBCC SHOWCONTIG scanning 'geminiappsettings' table...
Table: 'geminiappsettings' (151671588); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2301.0
- Avg. Page Density (full).....................: 71.57%
DBCC SHOWCONTIG scanning 'geminiaffectedversions' table...
Table: 'geminiaffectedversions' (173243672); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 87
- Extents Scanned..............................: 17
- Extent Switches..............................: 17
- Avg. Pages per Extent........................: 5.1
- Scan Density [Best Count:Actual Count].......: 61.11% [11:18]
- Logical Scan Fragmentation ..................: 16.09%
- Extent Scan Fragmentation ...................: 88.24%
- Avg. Bytes Free per Page.....................: 5231.2
- Avg. Page Density (full).....................: 35.37%
DBCC SHOWCONTIG scanning 'geminiissuelinks' table...
Table: 'geminiissuelinks' (192719739); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]
- Logical Scan Fragmentation ..................: 75.00%
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 1479.8
- Avg. Page Density (full).....................: 81.72%
DBCC SHOWCONTIG scanning 'EnvironmentList' table...
Table: 'EnvironmentList' (203147769); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8014.0
- Avg. Page Density (full).....................: 0.99%
DBCC SHOWCONTIG scanning 'geminiissueresources' table...
Table: 'geminiissueresources' (253243957); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 462
- Extents Scanned..............................: 66
- Extent Switches..............................: 66
- Avg. Pages per Extent........................: 7.0
- Scan Density [Best Count:Actual Count].......: 86.57% [58:67]
- Logical Scan Fragmentation ..................: 3.90%
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 2236.4
- Avg. Page Density (full).....................: 72.37%
DBCC SHOWCONTIG scanning 'components' table...
Table: 'components' (261575970); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7259.0
- Avg. Page Density (full).....................: 10.32%
DBCC SHOWCONTIG scanning 'securityschemes' table...
Table: 'securityschemes' (274100017); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7537.0
- Avg. Page Density (full).....................: 6.88%
DBCC SHOWCONTIG scanning 'geminicustomfielddefinitions' table...
Table: 'geminicustomfielddefinitions' (304720138); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 13
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 3.3
- Scan Density [Best Count:Actual Count].......: 50.00% [2:4]
- Logical Scan Fragmentation ..................: 15.38%
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 1153.4
- Avg. Page Density (full).....................: 85.75%
DBCC SHOWCONTIG scanning 'geminiissuecomponents' table...
Table: 'geminiissuecomponents' (333244242); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 466
- Extents Scanned..............................: 66
- Extent Switches..............................: 65
- Avg. Pages per Extent........................: 7.1
- Scan Density [Best Count:Actual Count].......: 89.39% [59:66]
- Logical Scan Fragmentation ..................: 3.43%
- Extent Scan Fragmentation ...................: 69.70%
- Avg. Bytes Free per Page.....................: 2230.2
- Avg. Page Density (full).....................: 72.45%
DBCC SHOWCONTIG scanning 'issuealerts' table...
Table: 'issuealerts' (343672272); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'sourcecontrolissuefiles' table...
Table: 'sourcecontrolissuefiles' (354100302); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7764.0
- Avg. Page Density (full).....................: 4.08%
DBCC SHOWCONTIG scanning 'timetracking' table...
Table: 'timetracking' (386100416); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7880.0
- Avg. Page Density (full).....................: 2.64%
DBCC SHOWCONTIG scanning 'geminiappointments' table...
Table: 'geminiappointments' (404196490); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiglobalgroups' table...
Table: 'geminiglobalgroups' (413244527); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5790.0
- Avg. Page Density (full).....................: 28.47%
DBCC SHOWCONTIG scanning 'ClientList' table...
Table: 'ClientList' (427148567); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8059.0
- Avg. Page Density (full).....................: 0.43%
DBCC SHOWCONTIG scanning 'affectedversion' table...
Table: 'affectedversion' (439672614); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'NAYesNo' table...
Table: 'NAYesNo' (443148624); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8020.0
- Avg. Page Density (full).....................: 0.91%
DBCC SHOWCONTIG scanning 'NACheckoutDirect' table...
Table: 'NACheckoutDirect' (459148681); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7972.5
- Avg. Page Density (full).....................: 1.50%
DBCC SHOWCONTIG scanning 'projectrepository' table...
Table: 'projectrepository' (466100701); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7138.0
- Avg. Page Density (full).....................: 11.81%
DBCC SHOWCONTIG scanning 'NAProgramType' table...
Table: 'NAProgramType' (475148738); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7874.5
- Avg. Page Density (full).....................: 2.71%
DBCC SHOWCONTIG scanning 'geminiprojectresources' table...
Table: 'geminiprojectresources' (484196775); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'NAOffice' table...
Table: 'NAOffice' (491148795); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7897.5
- Avg. Page Density (full).....................: 2.43%
DBCC SHOWCONTIG scanning 'NADBD' table...
Table: 'NADBD' (507148852); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 4721.0
- Avg. Page Density (full).....................: 41.67%
DBCC SHOWCONTIG scanning 'geminiprojectgroups' table...
Table: 'geminiprojectgroups' (509244869); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7818.0
- Avg. Page Density (full).....................: 3.41%
DBCC SHOWCONTIG scanning 'issueresource' table...
Table: 'issueresource' (519672899); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 293
- Extents Scanned..............................: 38
- Extent Switches..............................: 37
- Avg. Pages per Extent........................: 7.7
- Scan Density [Best Count:Actual Count].......: 97.37% [37:38]
- Extent Scan Fragmentation ...................: 2.63%
- Avg. Bytes Free per Page.....................: 61.2
- Avg. Page Density (full).....................: 99.24%
DBCC SHOWCONTIG scanning 'NARCS' table...
Table: 'NARCS' (523148909); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 6889.0
- Avg. Page Density (full).....................: 14.89%
DBCC SHOWCONTIG scanning 'NAExecutive' table...
Table: 'NAExecutive' (539148966); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7646.5
- Avg. Page Density (full).....................: 5.53%
DBCC SHOWCONTIG scanning 'NAClass' table...
Table: 'NAClass' (555149023); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8045.0
- Avg. Page Density (full).....................: 0.61%
DBCC SHOWCONTIG scanning 'projectattributes' table...
Table: 'projectattributes' (578101100); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiversions' table...
Table: 'geminiversions' (580197117); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Logical Scan Fragmentation ..................: 66.67%
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 2536.0
- Avg. Page Density (full).....................: 68.67%
DBCC SHOWCONTIG scanning 'issuecomponent' table...
Table: 'issuecomponent' (583673127); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 295
- Extents Scanned..............................: 39
- Extent Switches..............................: 38
- Avg. Pages per Extent........................: 7.6
- Scan Density [Best Count:Actual Count].......: 94.87% [37:39]
- Extent Scan Fragmentation ...................: 17.95%
- Avg. Bytes Free per Page.....................: 36.2
- Avg. Page Density (full).....................: 99.55%
DBCC SHOWCONTIG scanning 'geminiglobalgroupmembership' table...
Table: 'geminiglobalgroupmembership' (589245154); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 20
- Extents Scanned..............................: 9
- Extent Switches..............................: 8
- Avg. Pages per Extent........................: 2.2
- Scan Density [Best Count:Actual Count].......: 33.33% [3:9]
- Logical Scan Fragmentation ..................: 35.00%
- Extent Scan Fragmentation ...................: 77.78%
- Avg. Bytes Free per Page.....................: 938.2
- Avg. Page Density (full).....................: 88.41%
DBCC SHOWCONTIG scanning 'geminiapplicationsettings' table...
Table: 'geminiapplicationsettings' (615673241); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 915.5
- Avg. Page Density (full).....................: 88.69%
DBCC SHOWCONTIG scanning 'Migration30TempGroups1' table...
Table: 'Migration30TempGroups1' (617769258); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 31
- Extents Scanned..............................: 7
- Extent Switches..............................: 6
- Avg. Pages per Extent........................: 4.4
- Scan Density [Best Count:Actual Count].......: 57.14% [4:7]
- Extent Scan Fragmentation ...................: 42.86%
- Avg. Bytes Free per Page.....................: 387.9
- Avg. Page Density (full).....................: 95.21%
DBCC SHOWCONTIG scanning 'projectversionattributes' table...
Table: 'projectversionattributes' (626101271); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiinstall' table...
Table: 'geminiinstall' (647673355); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8044.0
- Avg. Page Density (full).....................: 0.62%
DBCC SHOWCONTIG scanning 'projectversionattributevalues' table...
Table: 'projectversionattributevalues' (658101385); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'issuecomments' table...
Table: 'issuecomments' (661577395); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1263
- Extents Scanned..............................: 166
- Extent Switches..............................: 165
- Avg. Pages per Extent........................: 7.6
- Scan Density [Best Count:Actual Count].......: 95.18% [158:166]
- Extent Scan Fragmentation ...................: 98.80%
- Avg. Bytes Free per Page.....................: 390.3
- Avg. Page Density (full).....................: 95.18%
DBCC SHOWCONTIG scanning 'geminiprojectgroupmembership' table...
Table: 'geminiprojectgroupmembership' (669245439); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6266.0
- Avg. Page Density (full).....................: 22.58%
DBCC SHOWCONTIG scanning 'custfield' table...
Table: 'custfield' (681769486); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 3.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2836.7
- Avg. Page Density (full).....................: 64.95%
DBCC SHOWCONTIG scanning 'NAClient' table...
Table: 'NAClient' (683149479); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 9
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 4.5
- Scan Density [Best Count:Actual Count].......: 100.00% [2:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 1146.4
- Avg. Page Density (full).....................: 85.84%
DBCC SHOWCONTIG scanning 'geminicustomfieldusage' table...
Table: 'geminicustomfieldusage' (688721506); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Logical Scan Fragmentation ..................: 66.67%
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 2844.0
- Avg. Page Density (full).....................: 64.86%
DBCC SHOWCONTIG scanning 'userissuesview' table...
Table: 'userissuesview' (690101499); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 20
- Extents Scanned..............................: 10
- Extent Switches..............................: 9
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 30.00% [3:10]
- Extent Scan Fragmentation ...................: 90.00%
- Avg. Bytes Free per Page.....................: 1986.2
- Avg. Page Density (full).....................: 75.46%
DBCC SHOWCONTIG scanning 'geminisystemlog' table...
Table: 'geminisystemlog' (695673526); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 5883
- Extents Scanned..............................: 740
- Extent Switches..............................: 739
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 99.46% [736:740]
- Extent Scan Fragmentation ...................: 61.49%
- Avg. Bytes Free per Page.....................: 841.4
- Avg. Page Density (full).....................: 89.60%
DBCC SHOWCONTIG scanning 'CustomfielddataMBD' table...
Table: 'CustomfielddataMBD' (697769543); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.5
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 4143.3
- Avg. Page Density (full).....................: 48.81%
DBCC SHOWCONTIG scanning 'issuecommentsMBD' table...
Table: 'issuecommentsMBD' (713769600); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 3.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5277.7
- Avg. Page Density (full).....................: 34.80%
DBCC SHOWCONTIG scanning 'issuestatusbuck' table...
Table: 'issuestatusbuck' (715149593); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7391.0
- Avg. Page Density (full).....................: 8.69%
DBCC SHOWCONTIG scanning 'issueattachMBD' table...
Table: 'issueattachMBD' (729769657); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7168.0
- Avg. Page Density (full).....................: 11.44%
DBCC SHOWCONTIG scanning 'issuetypelut' table...
Table: 'issuetypelut' (738101670); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7125.0
- Avg. Page Density (full).....................: 11.97%
DBCC SHOWCONTIG scanning 'issuehistoryMBD' table...
Table: 'issuehistoryMBD' (745769714); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4125.5
- Avg. Page Density (full).....................: 49.03%
DBCC SHOWCONTIG scanning 'issuehistory' table...
Table: 'issuehistory' (757577737); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 21703
- Extents Scanned..............................: 2721
- Extent Switches..............................: 2720
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.71% [2713:2721]
- Extent Scan Fragmentation ...................: 95.11%
- Avg. Bytes Free per Page.....................: 294.4
- Avg. Page Density (full).....................: 96.36%
DBCC SHOWCONTIG scanning 'geminiglobalsecurityschemes' table...
Table: 'geminiglobalsecurityschemes' (759673754); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6304.0
- Avg. Page Density (full).....................: 22.12%
DBCC SHOWCONTIG scanning 'IssueResourcesMBD' table...
Table: 'IssueResourcesMBD' (761769771); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7861.0
- Avg. Page Density (full).....................: 2.88%
DBCC SHOWCONTIG scanning 'geminifieldvisibilityschemes' table...
Table: 'geminifieldvisibilityschemes' (765245781); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7936.0
- Avg. Page Density (full).....................: 1.95%
DBCC SHOWCONTIG scanning 'geminicustomfielddata' table...
Table: 'geminicustomfielddata' (768721791); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 11516
- Extents Scanned..............................: 1448
- Extent Switches..............................: 1857
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 77.50% [1440:1858]
- Logical Scan Fragmentation ..................: 5.94%
- Extent Scan Fragmentation ...................: 8.98%
- Avg. Bytes Free per Page.....................: 897.2
- Avg. Page Density (full).....................: 88.91%
DBCC SHOWCONTIG scanning 'issueprioritylut' table...
Table: 'issueprioritylut' (770101784); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7064.0
- Avg. Page Density (full).....................: 12.73%
DBCC SHOWCONTIG scanning 'geminicomponents' table...
Table: 'geminicomponents' (788197858); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6031.0
- Avg. Page Density (full).....................: 25.49%
DBCC SHOWCONTIG scanning 'issueattachments' table...
Table: 'issueattachments' (789577851); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 29
- Extents Scanned..............................: 14
- Extent Switches..............................: 13
- Avg. Pages per Extent........................: 2.1
- Scan Density [Best Count:Actual Count].......: 28.57% [4:14]
- Extent Scan Fragmentation ...................: 92.86%
- Avg. Bytes Free per Page.....................: 1670.3
- Avg. Page Density (full).....................: 79.36%
DBCC SHOWCONTIG scanning 'issuestatuslut' table...
Table: 'issuestatuslut' (802101898); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 6074.7
- Avg. Page Density (full).....................: 24.95%
DBCC SHOWCONTIG scanning 'issuestatuslut030309' table...
Table: 'issuestatuslut030309' (811149935); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 6401.0
- Avg. Page Density (full).....................: 20.92%
DBCC SHOWCONTIG scanning 'issuestatetransitionlut030309' table...
Table: 'issuestatetransitionlut030309' (827149992); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 5657.5
- Avg. Page Density (full).....................: 30.10%
DBCC SHOWCONTIG scanning 'geminiglobalsecurityschemeroles' table...
Table: 'geminiglobalsecurityschemeroles' (839674039); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 14
- Extents Scanned..............................: 9
- Extent Switches..............................: 8
- Avg. Pages per Extent........................: 1.6
- Scan Density [Best Count:Actual Count].......: 22.22% [2:9]
- Logical Scan Fragmentation ..................: 57.14%
- Extent Scan Fragmentation ...................: 88.89%
- Avg. Bytes Free per Page.....................: 671.0
- Avg. Page Density (full).....................: 91.71%
DBCC SHOWCONTIG scanning 'Client03032009' table...
Table: 'Client03032009' (843150049); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 8034.5
- Avg. Page Density (full).....................: 0.74%
DBCC SHOWCONTIG scanning 'geminifieldvisibilityschemeitems' table...
Table: 'geminifieldvisibilityschemeitems' (845246066); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4598.0
- Avg. Page Density (full).....................: 43.19%
DBCC SHOWCONTIG scanning 'issuestatusbuckbkup' table...
Table: 'issuestatusbuckbkup' (859150106); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7540.5
- Avg. Page Density (full).....................: 6.84%
DBCC SHOWCONTIG scanning 'issuestatetransitionlut' table...
Table: 'issuestatetransitionlut' (866102126); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 8
- Extents Scanned..............................: 8
- Extent Switches..............................: 7
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 12.50% [1:8]
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 5954.0
- Avg. Page Density (full).....................: 26.44%
DBCC SHOWCONTIG scanning 'tblBucket' table...
Table: 'tblBucket' (891150220); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7842.0
- Avg. Page Density (full).....................: 3.11%
DBCC SHOWCONTIG scanning 'geminipersonalfilters' table...
Table: 'geminipersonalfilters' (896722247); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 7
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 7.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 855.4
- Avg. Page Density (full).....................: 89.43%
DBCC SHOWCONTIG scanning 'geminiusers' table...
Table: 'geminiusers' (903674267); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 9
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 4.5
- Scan Density [Best Count:Actual Count].......: 100.00% [2:2]
- Logical Scan Fragmentation ..................: 11.11%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 986.0
- Avg. Page Density (full).....................: 87.82%
DBCC SHOWCONTIG scanning 'issueresolutionlut' table...
Table: 'issueresolutionlut' (914102297); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7048.0
- Avg. Page Density (full).....................: 12.92%
DBCC SHOWCONTIG scanning 'users' table...
Table: 'users' (917578307); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 11
- Extents Scanned..............................: 11
- Extent Switches..............................: 10
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 18.18% [2:11]
- Extent Scan Fragmentation ...................: 90.91%
- Avg. Bytes Free per Page.....................: 3285.6
- Avg. Page Density (full).....................: 59.41%
DBCC SHOWCONTIG scanning 'MeasuresSummary' table...
Table: 'MeasuresSummary' (923150334); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 7621.0
- Avg. Page Density (full).....................: 5.84%
DBCC SHOWCONTIG scanning 'IssuesTemp' table...
Table: 'IssuesTemp' (939150391); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiissueresolutions' table...
Table: 'geminiissueresolutions' (948198428); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7048.0
- Avg. Page Density (full).....................: 12.92%
DBCC SHOWCONTIG scanning 'geminifieldvisibilityschemeitemgroups' table...
Table: 'geminifieldvisibilityschemeitemgroups' (957246465); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1325.0
- Avg. Page Density (full).....................: 83.63%
DBCC SHOWCONTIG scanning 'issuerisklevellut' table...
Table: 'issuerisklevellut' (962102468); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7908.0
- Avg. Page Density (full).....................: 2.30%
DBCC SHOWCONTIG scanning 'geminiissuerisklevels' table...
Table: 'geminiissuerisklevels' (1012198656); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7908.0
- Avg. Page Density (full).....................: 2.30%
DBCC SHOWCONTIG scanning 'issuesbad' table...
Table: 'issuesbad' (1019150676); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 6
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 1.5
- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 2395.2
- Avg. Page Density (full).....................: 70.41%
DBCC SHOWCONTIG scanning 'geminiprojectdefaultvalues' table...
Table: 'geminiprojectdefaultvalues' (1021246693); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Logical Scan Fragmentation ..................: 50.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 2766.0
- Avg. Page Density (full).....................: 65.83%
DBCC SHOWCONTIG scanning 'userroles' table...
Table: 'userroles' (1045578763); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 14
- Extents Scanned..............................: 10
- Extent Switches..............................: 9
- Avg. Pages per Extent........................: 1.4
- Scan Density [Best Count:Actual Count].......: 20.00% [2:10]
- Extent Scan Fragmentation ...................: 90.00%
- Avg. Bytes Free per Page.....................: 3478.6
- Avg. Page Density (full).....................: 57.02%
DBCC SHOWCONTIG scanning 'geminiissues' table...
Table: 'geminiissues' (1060198827); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 8936
- Extents Scanned..............................: 1125
- Extent Switches..............................: 1186
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 94.10% [1117:1187]
- Logical Scan Fragmentation ..................: 1.38%
- Extent Scan Fragmentation ...................: 7.02%
- Avg. Bytes Free per Page.....................: 1488.5
- Avg. Page Density (full).....................: 81.61%
DBCC SHOWCONTIG scanning 'geminiversionmilestone' table...
Table: 'geminiversionmilestone' (1117247035); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiissuetypes' table...
Table: 'geminiissuetypes' (1127675065); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 5426.0
- Avg. Page Density (full).....................: 32.96%
DBCC SHOWCONTIG scanning 'usersettings' table...
Table: 'usersettings' (1157579162); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 11
- Extents Scanned..............................: 11
- Extent Switches..............................: 10
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 18.18% [2:11]
- Extent Scan Fragmentation ...................: 90.91%
- Avg. Bytes Free per Page.....................: 3939.6
- Avg. Page Density (full).....................: 51.33%
DBCC SHOWCONTIG scanning 'issues' table...
Table: 'issues' (1179151246); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1533
- Extents Scanned..............................: 196
- Extent Switches..............................: 195
- Avg. Pages per Extent........................: 7.8
- Scan Density [Best Count:Actual Count].......: 97.96% [192:196]
- Extent Scan Fragmentation ...................: 98.47%
- Avg. Bytes Free per Page.....................: 301.5
- Avg. Page Density (full).....................: 96.27%
DBCC SHOWCONTIG scanning 'geminimailboxprocessor' table...
Table: 'geminimailboxprocessor' (1229247434); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'watchissue' table...
Table: 'watchissue' (1237579447); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 478
- Extents Scanned..............................: 70
- Extent Switches..............................: 69
- Avg. Pages per Extent........................: 6.8
- Scan Density [Best Count:Actual Count].......: 85.71% [60:70]
- Extent Scan Fragmentation ...................: 97.14%
- Avg. Bytes Free per Page.....................: 445.7
- Avg. Page Density (full).....................: 94.49%
DBCC SHOWCONTIG scanning 'geminiissuetypeschemes' table...
Table: 'geminiissuetypeschemes' (1255675521); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7410.0
- Avg. Page Density (full).....................: 8.45%
DBCC SHOWCONTIG scanning 'watchproject' table...
Table: 'watchproject' (1317579732); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 8025.8
- Avg. Page Density (full).....................: 0.84%
DBCC SHOWCONTIG scanning 'geminiissuetypeschemeitems' table...
Table: 'geminiissuetypeschemeitems' (1319675749); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6029.0
- Avg. Page Density (full).....................: 25.51%
DBCC SHOWCONTIG scanning 'geminiissuepriorities' table...
Table: 'geminiissuepriorities' (1399676034); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5866.0
- Avg. Page Density (full).....................: 27.53%
DBCC SHOWCONTIG scanning 'geminiissuepriorityschemes' table...
Table: 'geminiissuepriorityschemes' (1447676205); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7702.0
- Avg. Page Density (full).....................: 4.84%
DBCC SHOWCONTIG scanning 'geminisourcecontrolissuefiles' table...
Table: 'geminisourcecontrolissuefiles' (1472724299); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7891.0
- Avg. Page Density (full).....................: 2.51%
DBCC SHOWCONTIG scanning 'geminiissuecomments' table...
Table: 'geminiissuecomments' (1492200366); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 7648
- Extents Scanned..............................: 964
- Extent Switches..............................: 1022
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 93.45% [956:1023]
- Logical Scan Fragmentation ..................: 3.39%
- Extent Scan Fragmentation ...................: 8.30%
- Avg. Bytes Free per Page.....................: 939.9
- Avg. Page Density (full).....................: 88.39%
DBCC SHOWCONTIG scanning 'issuelinktypes' table...
Table: 'issuelinktypes' (1493580359); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7702.0
- Avg. Page Density (full).....................: 4.84%
DBCC SHOWCONTIG scanning 'geminiissuepriorityschemeitems' table...
Table: 'geminiissuepriorityschemeitems' (1511676433); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7195.0
- Avg. Page Density (full).....................: 11.11%
DBCC SHOWCONTIG scanning 'NARequestType' table...
Table: 'NARequestType' (1531152500); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7950.0
- Avg. Page Density (full).....................: 1.78%
DBCC SHOWCONTIG scanning 'geminiissuetimetype' table...
Table: 'geminiissuetimetype' (1536724527); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'NASPC' table...
Table: 'NASPC' (1547152557); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7866.0
- Avg. Page Density (full).....................: 2.82%
DBCC SHOWCONTIG scanning 'issuelinks' table...
Table: 'issuelinks' (1557580587); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 8
- Extents Scanned..............................: 8
- Extent Switches..............................: 7
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 12.50% [1:8]
- Extent Scan Fragmentation ...................: 87.50%
- Avg. Bytes Free per Page.....................: 7551.6
- Avg. Page Density (full).....................: 6.70%
DBCC SHOWCONTIG scanning 'geminiissueseverity' table...
Table: 'geminiissueseverity' (1591676718); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6680.0
- Avg. Page Density (full).....................: 17.47%
DBCC SHOWCONTIG scanning 'geminitimetracking' table...
Table: 'geminitimetracking' (1616724812); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7871.0
- Avg. Page Density (full).....................: 2.76%
DBCC SHOWCONTIG scanning 'geminisavedreports' table...
Table: 'geminisavedreports' (1629248859); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'customfielddefs' table...
Table: 'customfielddefs' (1637580872); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 11
- Extents Scanned..............................: 9
- Extent Switches..............................: 8
- Avg. Pages per Extent........................: 1.2
- Scan Density [Best Count:Actual Count].......: 22.22% [2:9]
- Extent Scan Fragmentation ...................: 88.89%
- Avg. Bytes Free per Page.....................: 1325.3
- Avg. Page Density (full).....................: 83.63%
DBCC SHOWCONTIG scanning 'geminiissueseverityschemes' table...
Table: 'geminiissueseverityschemes' (1639676889); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7798.0
- Avg. Page Density (full).....................: 3.66%
DBCC SHOWCONTIG scanning 'geminiissuehistory' table...
Table: 'geminiissuehistory' (1668200993); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 28058
- Extents Scanned..............................: 3509
- Extent Switches..............................: 3508
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.97% [3508:3509]
- Extent Scan Fragmentation ...................: 14.96%
- Avg. Bytes Free per Page.....................: 133.9
- Avg. Page Density (full).....................: 98.35%
DBCC SHOWCONTIG scanning 'geminiissueseverityschemeitems' table...
Table: 'geminiissueseverityschemeitems' (1703677117); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7513.0
- Avg. Page Density (full).....................: 7.18%
DBCC SHOWCONTIG scanning 'dtproperties' table...
Table: 'dtproperties' (1774629365); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiprojectdocuments' table...
Table: 'geminiprojectdocuments' (1776725382); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7398.0
- Avg. Page Density (full).....................: 8.60%
DBCC SHOWCONTIG scanning 'geminiissueattachments' table...
Table: 'geminiissueattachments' (1780201392); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 66
- Extents Scanned..............................: 11
- Extent Switches..............................: 10
- Avg. Pages per Extent........................: 6.0
- Scan Density [Best Count:Actual Count].......: 81.82% [9:11]
- Extent Scan Fragmentation ...................: 90.91%
- Avg. Bytes Free per Page.....................: 627.9
- Avg. Page Density (full).....................: 92.24%
DBCC SHOWCONTIG scanning 'geminiissuestatus' table...
Table: 'geminiissuestatus' (1783677402); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Logical Scan Fragmentation ..................: 50.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 854.5
- Avg. Page Density (full).....................: 89.44%
DBCC SHOWCONTIG scanning 'geminireports' table...
Table: 'geminireports' (1837249600); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6720.0
- Avg. Page Density (full).....................: 16.98%
DBCC SHOWCONTIG scanning 'geminiissueworkflow' table...
Table: 'geminiissueworkflow' (1847677630); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6634.0
- Avg. Page Density (full).....................: 18.04%
DBCC SHOWCONTIG scanning 'geminiprojectattributes' table...
Table: 'geminiprojectattributes' (1904725838); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiusersettings' table...
Table: 'geminiusersettings' (1924201905); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 15
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 5.0
- Scan Density [Best Count:Actual Count].......: 66.67% [2:3]
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 2202.1
- Avg. Page Density (full).....................: 72.79%
DBCC SHOWCONTIG scanning 'geminiissueworkflowitem' table...
Table: 'geminiissueworkflowitem' (1927677915); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1874.0
- Avg. Page Density (full).....................: 76.85%
DBCC SHOWCONTIG scanning 'geminireportsvisibility' table...
Table: 'geminireportsvisibility' (1933249942); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'geminiinstall' table...
Table: 'geminiinstall' (1977058079); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8044.0
- Avg. Page Density (full).....................: 0.62%
DBCC SHOWCONTIG scanning 'geminiprojectversionattributes' table...
Table: 'geminiprojectversionattributes' (1984726123); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'customfielddata' table...
Table: 'customfielddata' (1989582126); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 9155
- Extents Scanned..............................: 1149
- Extent Switches..............................: 1148
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.65% [1145:1149]
- Extent Scan Fragmentation ...................: 98.69%
- Avg. Bytes Free per Page.....................: 375.5
- Avg. Page Density (full).....................: 95.36%
DBCC SHOWCONTIG scanning 'geminiwatchissues' table...
Table: 'geminiwatchissues' (2004202190); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 530
- Extents Scanned..............................: 71
- Extent Switches..............................: 70
- Avg. Pages per Extent........................: 7.5
- Scan Density [Best Count:Actual Count].......: 94.37% [67:71]
- Extent Scan Fragmentation ...................: 87.32%
- Avg. Bytes Free per Page.....................: 134.9
- Avg. Page Density (full).....................: 98.33%
DBCC SHOWCONTIG scanning 'errorlog' table...
Table: 'errorlog' (2009058193); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 11324
- Extents Scanned..............................: 1423
- Extent Switches..............................: 1422
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.51% [1416:1423]
- Extent Scan Fragmentation ...................: 45.19%
- Avg. Bytes Free per Page.....................: 355.9
- Avg. Page Density (full).....................: 95.60%
DBCC SHOWCONTIG scanning 'geminiissueworkflowitemgroup' table...
Table: 'geminiissueworkflowitemgroup' (2023678257); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Logical Scan Fragmentation ..................: 50.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3301.0
- Avg. Page Density (full).....................: 59.22%
DBCC SHOWCONTIG scanning 'personalfilters' table...
Table: 'personalfilters' (2037582297); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 13
- Extents Scanned..............................: 9
- Extent Switches..............................: 8
- Avg. Pages per Extent........................: 1.4
- Scan Density [Best Count:Actual Count].......: 22.22% [2:9]
- Extent Scan Fragmentation ...................: 88.89%
- Avg. Bytes Free per Page.....................: 3875.5
- Avg. Page Density (full).....................: 52.12%
DBCC SHOWCONTIG scanning 'geminiprojectversionattributevalues' table...
Table: 'geminiprojectversionattributevalues' (2048726351); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'NAPrintLevels' table...
Table: 'NAPrintLevels' (2059154381); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7959.0
- Avg. Page Density (full).....................: 1.67%
DBCC SHOWCONTIG scanning 'projects' table...
Table: 'projects' (2089058478); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6490.0
- Avg. Page Density (full).....................: 19.82%
DBCC SHOWCONTIG scanning 'geminiwatchproject' table...
Table: 'geminiwatchproject' (2100202532); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Extent Scan Fragmentation ...................: 33.33%
- Avg. Bytes Free per Page.....................: 7776.3
- Avg. Page Density (full).....................: 3.92%
DBCC SHOWCONTIG scanning 'geminiissueworkflowitemtransition' table...
Table: 'geminiissueworkflowitemtransition' (2103678542); index ID: 1, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 5
- Extents Scanned..............................: 5
- Extent Switches..............................: 4
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 20.00% [1:5]
- Logical Scan Fragmentation ..................: 80.00%
- Extent Scan Fragmentation ...................: 60.00%
- Avg. Bytes Free per Page.....................: 1971.6
- Avg. Page Density (full).....................: 75.64%
DBCC SHOWCONTIG scanning 'Issues01062009' table...
Table: 'Issues01062009' (2123154609); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 144
- Extents Scanned..............................: 19
- Extent Switches..............................: 18
- Avg. Pages per Extent........................: 7.6
- Scan Density [Best Count:Actual Count].......: 94.74% [18:19]
- Extent Scan Fragmentation ...................: 5.26%
- Avg. Bytes Free per Page.....................: 241.3
- Avg. Page Density (full).....................: 97.02%
DBCC SHOWCONTIG scanning 'IssueHistory01062009' table...
Table: 'IssueHistory01062009' (2139154666); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 1454
- Extents Scanned..............................: 183
- Extent Switches..............................: 182
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 99.45% [182:183]
- Extent Scan Fragmentation ...................: 1.09%
- Avg. Bytes Free per Page.....................: 100.0
- Avg. Page Density (full).....................: 98.76%
DBCC SHOWCONTIG scanning 'geminiuserissuesviews' table...
Table: 'gemini_userissuesviews' (2144726693); index ID: 0, database ID: 9
TABLE level scan performed.
- Pages Scanned................................: 22
- Extents Scanned..............................: 6
- Extent Switches..............................: 5
- Avg. Pages per Extent........................: 3.7
- Scan Density [Best Count:Actual Count].......: 50.00% [3:6]
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 1860.6
- Avg. Page Density (full).....................: 77.01%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

 

Thanks

Vinay

So is the issue with exporting only? how mnay issues are you exporting?