Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Performance Issues - Identical Databases

Author  Topic 

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-22 : 11:54:18
Hello Everyone,

I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a
development web server. Both are running SQL Server 2000.

I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So I tested the query on the Development server by taking a backup (.dmp) of the database and moving it onto the dev server. I ran the same query and found that it ran in less than a second.

I took a look at the query execution plan and I found that they we're
the exact same in both cases.

Then I took a look at the various index's, and again I found no
differences in the table indices.

If both databases are identical, I'm assumeing that the issue is
related to some external hardware issue like: disk space, memory etc.
Or could it be OS software related issues, like service packs, SQL
Server configuations etc.

Here's what I've done to rule out some obvious hardware issues on the
prod server:
1. Moved all extraneous files to a secondary harddrive to free up space on the primary harddrive. There is 55gb's of free space on the disk.
2. Applied SQL Server SP4 service packs
3. Defragmented the primary harddrive
4. Applied all Windows Server 2003 updates


Here is the prod servers system specs:
2x Intel Xeon 2.67GHZ
Total Physical Memory 2GB, Available Physical Memory 815MB
Windows Server 2003 SE /w SP1

Here is the dev serers system specs:
2x Intel Xeon 2.80GHz
2GB DDR2-SDRAM
Windows Server 2003 SE /w SP1

I'm not sure what else to do, the query performance is an order
of magnitude difference and I can't explain it. To me its is a hardware or operating system related issue.

Any Ideas would help me greatly!

Thanks,
Brian T

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts
Posted - 2006-06-22 : 12:33:38
Could also be network related.....ie one segment running @ 10mb, 1 @1mb per sec....etc.
Not all performance problems are tied to the the SQL engine/SQL machine...sometimes it's to do with the speed of the wires between you and them!
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-22 : 12:47:07
Is there any way I can test for this?
Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts
Posted - 2006-06-23 : 08:34:18
Search here for other instances of "network" "performance"....some of the others have reported problems in this arena...not sure if they named the tools used to trace it.
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-26 : 12:34:33
Hello everyone,

I have an update to this thread on some of the progress I've made since.

I manged to look at the text based actual query execution plan on the different servers and I found some very minute differences in the plan. These differences are in the following format: Nested Loops(Inner Join, OURTER REFERENCES: (TABLE.COLUMN)). Now on both servers the table is the same, but the difference between both servers is in the column value. There is also a clustered index seek difference. Here is the difference: Clustered Index Seek(OBJECT(___), SEEK(____) ORDERED FORWARD) both of the ____ objects are different in prod rather then dev.

So I made sure that the index's on both servers we're the EXACT same, and that has been verified. So here are my questions:
1. What else affects query execution plans?
2. How can I find out if the difference in the execution plans, results in the difference in execution time?

Any help would be greatly appreciated!

Thanks,
Brian
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts
Posted - 2006-06-26 : 13:14:53
Have you updated stats or done a reindex yet?

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights.
Go to Top of Page

Kristen
Test

22859 Posts
Posted - 2006-06-26 : 13:49:37
"Have you updated stats or done a reindex yet?"

Damn! I was just going to say that!

Restoring the database onto the second server will cause it to start with a clean-slate of in-memory cached-stuff (that's a technical term!)

So you may find that the Product Database will also be improved by just stop-starting the SQL Service ...

.. and if that turns out to be the case you need to work out what has deteriorating statistics, and thus the cached query plan becomes stale and inappropriate, and then sp_recompile it J.I.T.

Kristen
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts
Posted - 2006-06-26 : 13:57:24
quote:
Originally posted by AFTIadmin
1. What else affects query execution plans?
2. How can I find out if the difference in the execution plans, results


1. statistics
2. make sure to set SET STATISTICS TIME ON and SET STATISTICS IO ON in query analyzer and you will get IO and timing information for each query.

also, I always use iperf 1.7 for measuring network throuput. you can get that here http://dast.nlanr.net/Projects/Iperf/#newfeatures. Your NICs should be set to 100/FULL if they are 100mbit (do not set them to AUTO). IF you have gigabit NICs then auto is the correct setting.



-ec
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-26 : 18:48:08
Hi Kristen and ec,

I tried what you have suggested. I stopped and started sql server (clearing any cache), then tested out the query and it still had bad performance.

As for statistics, I updated the statistics on the prod server for all relevant tables and ran the query again and analysed the query execution plan. They we're both identical but I still had the performance difference on both servers. Is there a way to view the execution time of each specific line of execution.

here is what I get for statistics time on and IO

Prod:
Table '#219FF574'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0.
Table 'T_1'. Scan count 11, logical reads 22, physical reads 0, read-ahead reads 0.
Table 'T_2. Scan count 14, logical reads 35, physical reads 0, read-ahead reads 0.
Table 'T_3. Scan count 10, logical reads 45, physical reads 0, read-ahead reads 0.
Table 'T_4. Scan count 10, logical reads 20, physical reads 0, read-ahead reads 0.
Table 'T_5. Scan count 4, logical reads 16, physical reads 0, read-ahead reads 0.

SQL Server Execution Times:
CPU time = 4656 ms, elapsed time = 4664 ms.

SQL Server Execution Times:
CPU time = 4656 ms, elapsed time = 4665 ms.


Dev:
Table '#6FFB1919'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0.
Table 'T_1. Scan count 11, logical reads 22, physical reads 0, read-ahead reads 0.
Table 'T_2. Scan count 14, logical reads 35, physical reads 0, read-ahead reads 0.
Table 'T_3. Scan count 10, logical reads 45, physical reads 0, read-ahead reads 0.
Table 'T_4. Scan count 10, logical reads 20, physical reads 0, read-ahead reads 0.
Table 'T_5. Scan count 4, logical reads 16, physical reads 0, read-ahead reads 0.

SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 4 ms.

SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 4 ms.

Any other ideas? thanks guys

Brian
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts
Posted - 2006-06-26 : 22:56:13
are you running your query locally or from a remote machine?

have you tried testing with iperf to see there is a difference in network peformance between the two systems?



-ec
Go to Top of Page

Kristen
Test

22859 Posts
Posted - 2006-06-27 : 00:04:22
"Any other ideas? "

Yes, they are doing the same amount of work, but your PROD server is 1,000 times slower!

I would consider:

Is CPU busy on PROD server - if so something else is stealing CPU.

If not is it trashing the page file?

Otherwise the network performance is off (as EC said), or you've a dead disk in your RAID and no-one has noticed, or some other fault is causing hardware re-tries

Kristen
Go to Top of Page

CSK
Constraint Violating Yak Guru

489 Posts
Posted - 2006-06-27 : 00:14:31
Try reindex


--KK
Go to Top of Page

Kristen
Test

22859 Posts
Posted - 2006-06-27 : 00:19:37
I don't think the "statistics time" would show the same for PROD and DEV if the indexes were fragged, would they?

However, if there's a chance they are out of whack:

1) Defrag indexes

2) Update stats (not required if you did REINDEX rather than DEFRAG - unless you have non-unique clustered indexes, or somesuch GotCha, so maybe rebuild the stats anyway!)

3) StopStart SQL to force everything to sp_recompile etc

Kristen
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts
Posted - 2006-06-27 : 02:30:20
quote:
Originally posted by CSK

Try reindex


I would be surprised if this is the solution, my experience has been that this is rarely the case. Especially when the STATISTICS IO are the same. Usually it is network performance related (maybe errors at your switch), or as Kristen suggested a RAID volume that is running degraded. Worth a shot though I suppose.

Check for hardware issues as we suggested and follow Kristen's steps to defrag create new stats, then get back to us.


-ec
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2006-06-27 : 03:26:06
How about physical defragmentation?
Even if all pages are defragmented, doesn't mean that the pages are defragmented on disc.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts
Posted - 2006-06-27 : 04:11:28
quote:
Originally posted by Peso

How about physical defragmentation?
Even if all pages are defragmented, doesn't mean that the pages are defragmented on disc.



good point. I use a tool from sysinternals to check this. They have a free command line tool called contig that you can run against your datafiles and generate a report.

It can also be used to defrag those same files, but you will need to take the database offline to do that.

http://www.sysinternals.com/Utilities/Contig.html



-ec
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-27 : 10:32:25
eyechart:
"are you running your query locally or from a remote machine?"
I'm running the query in query analyser remotely through RDP.

"have you tried testing with iperf to see there is a difference in network peformance between the two systems?"
No I havn't yet, I will download that today and let you know how it goes. Thanks for the tip!


Kristen:
"Is CPU busy on PROD server - if so something else is stealing CPU."
No the CPU have very little activity, I checked all the cpu counters in perfmon and cpu activity is almost always below 10%.

"If not is it trashing the page file?"
This is how the server is setup: two physical 63gb hds in RAID 1, these hold the os and the db. We also have a separate fast and small (secondary) hd which holds our os page file. Now originally we had the swap file on the raid 1 array and had our performance difficulties, then we moved the swap file to a separate smaller and faster disk to see if it would help any. It didn't, but we are keeping the configuration like this for now.

About dead disks in the raid, how would I be able to test for this? I did rule out one thing though. I moved the ldf and mdf db files to our secondary hd and tested out if the query was any faster. But there was no noticable difference, still the same bad performance.

CSK:
"Try reindex"
I've reciently reindexed all my data tables here is what showcontig returns:
DBCC SHOWCONTIG scanning 'sysobjects' table...
Table: 'sysobjects' (1); index ID: 1, database ID: 11
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 ..................: 40.00%
- Extent Scan Fragmentation ...................: 80.00%
- Avg. Bytes Free per Page.....................: 2806.4
- Avg. Page Density (full).....................: 65.33%
DBCC SHOWCONTIG scanning 'sysindexes' table...
Table: 'sysindexes' (2); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 26
- Extents Scanned..............................: 10
- Extent Switches..............................: 17
- Avg. Pages per Extent........................: 2.6
- Scan Density [Best Count:Actual Count].......: 22.22% [4:18]
- Logical Scan Fragmentation ..................: 57.69%
- Extent Scan Fragmentation ...................: 90.00%
- Avg. Bytes Free per Page.....................: 4340.2
- Avg. Page Density (full).....................: 46.38%
DBCC SHOWCONTIG scanning 'syscolumns' table...
Table: 'syscolumns' (3); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 37
- Extents Scanned..............................: 11
- Extent Switches..............................: 26
- Avg. Pages per Extent........................: 3.4
- Scan Density [Best Count:Actual Count].......: 18.52% [5:27]
- Logical Scan Fragmentation ..................: 29.73%
- Extent Scan Fragmentation ...................: 81.82%
- Avg. Bytes Free per Page.....................: 4241.9
- Avg. Page Density (full).....................: 47.59%
DBCC SHOWCONTIG scanning 'systypes' table...
Table: 'systypes' (4); index ID: 1, database ID: 11
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.....................: 6712.0
- Avg. Page Density (full).....................: 17.07%
DBCC SHOWCONTIG scanning 'syscomments' table...
Table: 'syscomments' (6); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 45
- Extents Scanned..............................: 9
- Extent Switches..............................: 32
- Avg. Pages per Extent........................: 5.0
- Scan Density [Best Count:Actual Count].......: 18.18% [6:33]
- Logical Scan Fragmentation ..................: 37.78%
- Extent Scan Fragmentation ...................: 44.44%
- Avg. Bytes Free per Page.....................: 3922.7
- Avg. Page Density (full).....................: 51.54%
DBCC SHOWCONTIG scanning 'sysfiles1' table...
Table: 'sysfiles1' (8); index ID: 0, database ID: 11
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.....................: 6508.0
- Avg. Page Density (full).....................: 19.59%
DBCC SHOWCONTIG scanning 'syspermissions' table...
Table: 'syspermissions' (9); index ID: 1, database ID: 11
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.....................: 6996.0
- Avg. Page Density (full).....................: 13.57%
DBCC SHOWCONTIG scanning 'sysusers' table...
Table: 'sysusers' (10); index ID: 1, database ID: 11
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.....................: 7222.0
- Avg. Page Density (full).....................: 10.77%
DBCC SHOWCONTIG scanning 'sysproperties' table...
Table: 'sysproperties' (11); index ID: 1, database ID: 11
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.....................: 1368.0
- Avg. Page Density (full).....................: 83.10%
DBCC SHOWCONTIG scanning 'sysdepends' table...
Table: 'sysdepends' (12); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 6
- Extents Scanned..............................: 6
- Extent Switches..............................: 5
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 16.67% [1:6]
- Logical Scan Fragmentation ..................: 16.67%
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 3511.3
- Avg. Page Density (full).....................: 56.62%
DBCC SHOWCONTIG scanning 'sysreferences' table...
Table: 'sysreferences' (14); index ID: 1, database ID: 11
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.....................: 7526.0
- Avg. Page Density (full).....................: 7.02%
DBCC SHOWCONTIG scanning 'sysfilegroups' table...
Table: 'sysfilegroups' (96); index ID: 1, database ID: 11
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.....................: 8058.0
- Avg. Page Density (full).....................: 0.44%
DBCC SHOWCONTIG scanning 'T_NET_EMPLOYEE' table...
Table: 'T_NET_EMPLOYEE' (4195065); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 1727.7
- Avg. Page Density (full).....................: 78.65%
DBCC SHOWCONTIG scanning 'T_ESCALATION_LIST' table...
Table: 'T_ESCALATION_LIST' (11147085); index ID: 0, database ID: 11
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]
- Extent Scan Fragmentation ...................: 60.00%
- Avg. Bytes Free per Page.....................: 7540.8
- Avg. Page Density (full).....................: 6.83%
DBCC SHOWCONTIG scanning 'T_NET_JOURNAL' table...
Table: 'T_NET_JOURNAL' (14623095); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3107.5
- Avg. Page Density (full).....................: 61.61%
DBCC SHOWCONTIG scanning 'T_NET_LOOKUP' table...
Table: 'T_NET_LOOKUP' (110623437); index ID: 1, database ID: 11
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.....................: 3076.0
- Avg. Page Density (full).....................: 62.00%
DBCC SHOWCONTIG scanning 'PE_T_EMail' table...
Table: 'PE_T_EMail' (148195578); index ID: 0, database ID: 11
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.....................: 7955.0
- Avg. Page Density (full).....................: 1.72%
DBCC SHOWCONTIG scanning 'T_NET_PERF_MONITOR' table...
Table: 'T_NET_PERF_MONITOR' (174623665); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 2401
- Extents Scanned..............................: 301
- Extent Switches..............................: 300
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 100.00% [301:301]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1802.6
- Avg. Page Density (full).....................: 77.73%
DBCC SHOWCONTIG scanning 'PE_T_DeviceIDs' table...
Table: 'PE_T_DeviceIDs' (180195692); index ID: 0, database ID: 11
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.....................: 7882.0
- Avg. Page Density (full).....................: 2.62%
DBCC SHOWCONTIG scanning 'T_UNIT' table...
Table: 'T_UNIT' (206623779); index ID: 1, database ID: 11
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.....................: 3863.0
- Avg. Page Density (full).....................: 52.27%
DBCC SHOWCONTIG scanning 'T_EQUIP_TYPE_VARIABLE' table...
Table: 'T_EQUIP_TYPE_VARIABLE' (231671873); index ID: 1, database ID: 11
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.....................: 2994.0
- Avg. Page Density (full).....................: 63.01%
DBCC SHOWCONTIG scanning 'PITRX_T_DeviceIDs' table...
Table: 'PITRX_T_DeviceIDs' (244195920); index ID: 0, database ID: 11
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.....................: 8028.0
- Avg. Page Density (full).....................: 0.82%
DBCC SHOWCONTIG scanning 'T_USER_PREFERENCE' table...
Table: 'T_USER_PREFERENCE' (254623950); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 33.33%
- Avg. Bytes Free per Page.....................: 2601.3
- Avg. Page Density (full).....................: 67.86%
DBCC SHOWCONTIG scanning 'PITRX_T_EMail' table...
Table: 'PITRX_T_EMail' (260195977); index ID: 0, database ID: 11
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.....................: 7978.0
- Avg. Page Density (full).....................: 1.43%
DBCC SHOWCONTIG scanning 'T_DAYS' table...
Table: 'T_DAYS' (373576369); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 22
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 7.3
- Scan Density [Best Count:Actual Count].......: 100.00% [3:3]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 177.3
- Avg. Page Density (full).....................: 97.81%
DBCC SHOWCONTIG scanning 'T_DATE_RANGE' table...
Table: 'T_DATE_RANGE' (389576426); index ID: 1, database ID: 11
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.....................: 6282.0
- Avg. Page Density (full).....................: 22.39%
DBCC SHOWCONTIG scanning 'DUAL' table...
Table: 'DUAL' (546100986); index ID: 0, database ID: 11
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.....................: 8082.0
- Avg. Page Density (full).....................: 0.15%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT' table...
Table: 'T_EQUIPMENT' (583673127); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 15
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 3.8
- Scan Density [Best Count:Actual Count].......: 50.00% [2:4]
- Logical Scan Fragmentation ..................: 6.67%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 771.5
- Avg. Page Density (full).....................: 90.47%
DBCC SHOWCONTIG scanning 'T_ALARM_STATE' table...
Table: 'T_ALARM_STATE' (711673583); index ID: 1, database ID: 11
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.....................: 2068.5
- Avg. Page Density (full).....................: 74.44%
DBCC SHOWCONTIG scanning 'T_UNIT_CONVERSION' table...
Table: 'T_UNIT_CONVERSION' (789577851); index ID: 1, database ID: 11
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.....................: 3798.0
- Avg. Page Density (full).....................: 53.08%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_VARIABLE' table...
Table: 'T_EQUIPMENT_VARIABLE' (791673868); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 121
- Extents Scanned..............................: 18
- Extent Switches..............................: 18
- Avg. Pages per Extent........................: 6.7
- Scan Density [Best Count:Actual Count].......: 84.21% [16:19]
- Logical Scan Fragmentation ..................: 1.65%
- Extent Scan Fragmentation ...................: 22.22%
- Avg. Bytes Free per Page.....................: 226.6
- Avg. Page Density (full).....................: 97.20%
DBCC SHOWCONTIG scanning 'T_ALARM_HISTORY' table...
Table: 'T_ALARM_HISTORY' (811149935); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 181
- Extents Scanned..............................: 26
- Extent Switches..............................: 25
- Avg. Pages per Extent........................: 7.0
- Scan Density [Best Count:Actual Count].......: 88.46% [23:26]
- Logical Scan Fragmentation ..................: 1.10%
- Extent Scan Fragmentation ...................: 88.46%
- Avg. Bytes Free per Page.....................: 107.8
- Avg. Page Density (full).....................: 98.67%
DBCC SHOWCONTIG scanning 'T_ALARM_RULE' table...
Table: 'T_ALARM_RULE' (887674210); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 270.0
- Avg. Page Density (full).....................: 96.66%
DBCC SHOWCONTIG scanning 'T_ASSET' table...
Table: 'T_ASSET' (1035150733); index ID: 0, database ID: 11
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.....................: 7911.0
- Avg. Page Density (full).....................: 2.26%
DBCC SHOWCONTIG scanning 'T_NET_EMPLOYEE_PERMISSION' table...
Table: 'T_NET_EMPLOYEE_PERMISSION' (1118627028); index ID: 0, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 9
- Extents Scanned..............................: 7
- Extent Switches..............................: 6
- Avg. Pages per Extent........................: 1.3
- Scan Density [Best Count:Actual Count].......: 28.57% [2:7]
- Extent Scan Fragmentation ...................: 57.14%
- Avg. Bytes Free per Page.....................: 6545.2
- Avg. Page Density (full).....................: 19.13%
DBCC SHOWCONTIG scanning 'T_NET_PERMISSION' table...
Table: 'T_NET_PERMISSION' (1150627142); index ID: 0, database ID: 11
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.....................: 7527.0
- Avg. Page Density (full).....................: 7.01%
DBCC SHOWCONTIG scanning 'T_NETWORK' table...
Table: 'T_NETWORK' (1243151474); index ID: 0, database ID: 11
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.....................: 7505.0
- Avg. Page Density (full).....................: 7.28%
DBCC SHOWCONTIG scanning 'T_COMPANY' table...
Table: 'T_COMPANY' (1262627541); index ID: 1, database ID: 11
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.....................: 5328.0
- Avg. Page Density (full).....................: 34.17%
DBCC SHOWCONTIG scanning 'T_OP_LOC_PARTNER' table...
Table: 'T_OP_LOC_PARTNER' (1294627655); index ID: 0, database ID: 11
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.....................: 7656.0
- Avg. Page Density (full).....................: 5.41%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_LOG_DATA' table...
Table: 'T_EQUIPMENT_LOG_DATA' (1303675692); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 24528
- Extents Scanned..............................: 3080
- Extent Switches..............................: 3151
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 97.27% [3066:3152]
- Logical Scan Fragmentation ..................: 0.25%
- Extent Scan Fragmentation ...................: 26.33%
- Avg. Bytes Free per Page.....................: 206.6
- Avg. Page Density (full).....................: 97.45%
DBCC SHOWCONTIG scanning 'T_CONCURRENCY' table...
Table: 'T_CONCURRENCY' (1310627712); index ID: 0, database ID: 11
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.....................: 8078.0
- Avg. Page Density (full).....................: 0.20%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_FORMULA' table...
Table: 'T_EQUIPMENT_FORMULA' (1351675863); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 23
- Extents Scanned..............................: 9
- Extent Switches..............................: 8
- Avg. Pages per Extent........................: 2.6
- Scan Density [Best Count:Actual Count].......: 33.33% [3:9]
- Logical Scan Fragmentation ..................: 17.39%
- Extent Scan Fragmentation ...................: 77.78%
- Avg. Bytes Free per Page.....................: 2702.1
- Avg. Page Density (full).....................: 66.62%
DBCC SHOWCONTIG scanning 'T_APPLICATION_VARIABLE' table...
Table: 'T_APPLICATION_VARIABLE' (1394104007); index ID: 1, database ID: 11
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.....................: 7595.0
- Avg. Page Density (full).....................: 6.17%
DBCC SHOWCONTIG scanning 'T_CHK_EXCEPTION_INDEX' table...
Table: 'T_CHK_EXCEPTION_INDEX' (1426104121); index ID: 1, database ID: 11
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.....................: 3099.0
- Avg. Page Density (full).....................: 61.71%
DBCC SHOWCONTIG scanning 'T_DOWNTIME' table...
Table: 'T_DOWNTIME' (1522104463); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1994.8
- Avg. Page Density (full).....................: 75.36%
DBCC SHOWCONTIG scanning 'T_DOWNTIME_CODE' table...
Table: 'T_DOWNTIME_CODE' (1554104577); index ID: 1, database ID: 11
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.....................: 4371.0
- Avg. Page Density (full).....................: 46.00%
DBCC SHOWCONTIG scanning 'T_LOCATION' table...
Table: 'T_LOCATION' (1559676604); index ID: 1, database ID: 11
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.....................: 2979.0
- Avg. Page Density (full).....................: 63.19%
DBCC SHOWCONTIG scanning 'T_DOWNTIME_TYPE' table...
Table: 'T_DOWNTIME_TYPE' (1586104691); index ID: 1, database ID: 11
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.....................: 7301.0
- Avg. Page Density (full).....................: 9.80%
DBCC SHOWCONTIG scanning 'T_NET_JOURNAL_TYPE' table...
Table: 'T_NET_JOURNAL_TYPE' (1639676889); index ID: 0, database ID: 11
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.....................: 7887.0
- Avg. Page Density (full).....................: 2.56%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_UNIT' table...
Table: 'T_EQUIPMENT_UNIT' (1687677060); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 1656.5
- Avg. Page Density (full).....................: 79.53%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_PROPERTY' table...
Table: 'T_EQUIPMENT_PROPERTY' (1714105147); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 56
- Extents Scanned..............................: 16
- Extent Switches..............................: 22
- Avg. Pages per Extent........................: 3.5
- Scan Density [Best Count:Actual Count].......: 30.43% [7:23]
- Logical Scan Fragmentation ..................: 16.07%
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 1907.6
- Avg. Page Density (full).....................: 76.43%
DBCC SHOWCONTIG scanning 'T_EQUIP_ATTRIBUTE_FILE' table...
Table: 'T_EQUIP_ATTRIBUTE_FILE' (1778105375); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3895.5
- Avg. Page Density (full).....................: 51.87%
DBCC SHOWCONTIG scanning 'T_EQUIP_TYPE' table...
Table: 'T_EQUIP_TYPE' (1842105603); index ID: 1, database ID: 11
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.....................: 7983.0
- Avg. Page Density (full).....................: 1.37%
DBCC SHOWCONTIG scanning 'T_EQUIP_TYPE_PROPERTY' table...
Table: 'T_EQUIP_TYPE_PROPERTY' (1874105717); index ID: 1, database ID: 11
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.....................: 7117.0
- Avg. Page Density (full).....................: 12.07%
DBCC SHOWCONTIG scanning 'T_MODEL' table...
Table: 'T_MODEL' (1970106059); index ID: 1, database ID: 11
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.....................: 7866.0
- Avg. Page Density (full).....................: 2.82%
DBCC SHOWCONTIG scanning 'T_MODEL_TYPE' table...
Table: 'T_MODEL_TYPE' (2002106173); index ID: 1, database ID: 11
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.....................: 8017.0
- Avg. Page Density (full).....................: 0.95%
DBCC SHOWCONTIG scanning 'T_MODEL_VARIABLE' table...
Table: 'T_MODEL_VARIABLE' (2034106287); index ID: 1, database ID: 11
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.....................: 8094.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'T_MONITOR' table...
Table: 'T_MONITOR' (2066106401); index ID: 1, database ID: 11
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.....................: 8094.0
- Avg. Page Density (full).....................: 0.00%
DBCC SHOWCONTIG scanning 'T_MONITOR_VARIABLE' table...
Table: 'T_MONITOR_VARIABLE' (2098106515); index ID: 1, database ID: 11
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.....................: 8094.0
- Avg. Page Density (full).....................: 0.00%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-27 : 11:05:03
Kristen:
1) Defrag indexes
2) Update stats (not required if you did REINDEX rather than DEFRAG - unless you have non-unique clustered indexes, or somesuch GotCha, so maybe rebuild the stats anyway!)
3) StopStart SQL to force everything to sp_recompile etc

Ok Kristen, I've tried all of these steps so many times, but I will do it again (step by step) just to make sure that I didn't miss anything. So this is what I will run for all base tables:
DBCC DBREINDEX('T_TABLE', '', 80)
UPDATE STATISTICS T_TABLE

Then I will restart sql and see what happens
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-27 : 11:26:52
Hi Guys
After performing the above, here is what showcontig returns:
DBCC SHOWCONTIG scanning 'sysobjects' table...
Table: 'sysobjects' (1); index ID: 1, database ID: 11
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 ..................: 40.00%
- Extent Scan Fragmentation ...................: 80.00%
- Avg. Bytes Free per Page.....................: 2806.4
- Avg. Page Density (full).....................: 65.33%
DBCC SHOWCONTIG scanning 'sysindexes' table...
Table: 'sysindexes' (2); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 26
- Extents Scanned..............................: 10
- Extent Switches..............................: 17
- Avg. Pages per Extent........................: 2.6
- Scan Density [Best Count:Actual Count].......: 22.22% [4:18]
- Logical Scan Fragmentation ..................: 57.69%
- Extent Scan Fragmentation ...................: 90.00%
- Avg. Bytes Free per Page.....................: 4335.5
- Avg. Page Density (full).....................: 46.44%
DBCC SHOWCONTIG scanning 'syscolumns' table...
Table: 'syscolumns' (3); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 37
- Extents Scanned..............................: 11
- Extent Switches..............................: 26
- Avg. Pages per Extent........................: 3.4
- Scan Density [Best Count:Actual Count].......: 18.52% [5:27]
- Logical Scan Fragmentation ..................: 29.73%
- Extent Scan Fragmentation ...................: 81.82%
- Avg. Bytes Free per Page.....................: 4241.9
- Avg. Page Density (full).....................: 47.59%
DBCC SHOWCONTIG scanning 'systypes' table...
Table: 'systypes' (4); index ID: 1, database ID: 11
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.....................: 6712.0
- Avg. Page Density (full).....................: 17.07%
DBCC SHOWCONTIG scanning 'syscomments' table...
Table: 'syscomments' (6); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 45
- Extents Scanned..............................: 9
- Extent Switches..............................: 32
- Avg. Pages per Extent........................: 5.0
- Scan Density [Best Count:Actual Count].......: 18.18% [6:33]
- Logical Scan Fragmentation ..................: 37.78%
- Extent Scan Fragmentation ...................: 44.44%
- Avg. Bytes Free per Page.....................: 3922.7
- Avg. Page Density (full).....................: 51.54%
DBCC SHOWCONTIG scanning 'sysfiles1' table...
Table: 'sysfiles1' (8); index ID: 0, database ID: 11
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.....................: 6508.0
- Avg. Page Density (full).....................: 19.59%
DBCC SHOWCONTIG scanning 'syspermissions' table...
Table: 'syspermissions' (9); index ID: 1, database ID: 11
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.....................: 6996.0
- Avg. Page Density (full).....................: 13.57%
DBCC SHOWCONTIG scanning 'sysusers' table...
Table: 'sysusers' (10); index ID: 1, database ID: 11
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.....................: 7222.0
- Avg. Page Density (full).....................: 10.77%
DBCC SHOWCONTIG scanning 'sysproperties' table...
Table: 'sysproperties' (11); index ID: 1, database ID: 11
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.....................: 1368.0
- Avg. Page Density (full).....................: 83.10%
DBCC SHOWCONTIG scanning 'sysdepends' table...
Table: 'sysdepends' (12); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 6
- Extents Scanned..............................: 6
- Extent Switches..............................: 5
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 16.67% [1:6]
- Logical Scan Fragmentation ..................: 16.67%
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 3511.3
- Avg. Page Density (full).....................: 56.62%
DBCC SHOWCONTIG scanning 'sysreferences' table...
Table: 'sysreferences' (14); index ID: 1, database ID: 11
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.....................: 7526.0
- Avg. Page Density (full).....................: 7.02%
DBCC SHOWCONTIG scanning 'sysfilegroups' table...
Table: 'sysfilegroups' (96); index ID: 1, database ID: 11
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.....................: 8058.0
- Avg. Page Density (full).....................: 0.44%
DBCC SHOWCONTIG scanning 'T_NET_EMPLOYEE' table...
Table: 'T_NET_EMPLOYEE' (4195065); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 1727.7
- Avg. Page Density (full).....................: 78.65%
DBCC SHOWCONTIG scanning 'T_ESCALATION_LIST' table...
Table: 'T_ESCALATION_LIST' (11147085); index ID: 0, database ID: 11
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]
- Extent Scan Fragmentation ...................: 60.00%
- Avg. Bytes Free per Page.....................: 7540.8
- Avg. Page Density (full).....................: 6.83%
DBCC SHOWCONTIG scanning 'T_NET_JOURNAL' table...
Table: 'T_NET_JOURNAL' (14623095); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3107.5
- Avg. Page Density (full).....................: 61.61%
DBCC SHOWCONTIG scanning 'T_NET_LOOKUP' table...
Table: 'T_NET_LOOKUP' (110623437); index ID: 1, database ID: 11
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.....................: 3076.0
- Avg. Page Density (full).....................: 62.00%
DBCC SHOWCONTIG scanning 'PE_T_EMail' table...
Table: 'PE_T_EMail' (148195578); index ID: 0, database ID: 11
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.....................: 7955.0
- Avg. Page Density (full).....................: 1.72%
DBCC SHOWCONTIG scanning 'T_NET_PERF_MONITOR' table...
Table: 'T_NET_PERF_MONITOR' (174623665); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 2405
- Extents Scanned..............................: 302
- Extent Switches..............................: 301
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.67% [301:302]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1813.0
- Avg. Page Density (full).....................: 77.60%
DBCC SHOWCONTIG scanning 'PE_T_DeviceIDs' table...
Table: 'PE_T_DeviceIDs' (180195692); index ID: 0, database ID: 11
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.....................: 7882.0
- Avg. Page Density (full).....................: 2.62%
DBCC SHOWCONTIG scanning 'T_UNIT' table...
Table: 'T_UNIT' (206623779); index ID: 1, database ID: 11
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.....................: 3863.0
- Avg. Page Density (full).....................: 52.27%
DBCC SHOWCONTIG scanning 'T_EQUIP_TYPE_VARIABLE' table...
Table: 'T_EQUIP_TYPE_VARIABLE' (231671873); index ID: 1, database ID: 11
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.....................: 2994.0
- Avg. Page Density (full).....................: 63.01%
DBCC SHOWCONTIG scanning 'PITRX_T_DeviceIDs' table...
Table: 'PITRX_T_DeviceIDs' (244195920); index ID: 0, database ID: 11
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.....................: 8028.0
- Avg. Page Density (full).....................: 0.82%
DBCC SHOWCONTIG scanning 'T_USER_PREFERENCE' table...
Table: 'T_USER_PREFERENCE' (254623950); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 2601.3
- Avg. Page Density (full).....................: 67.86%
DBCC SHOWCONTIG scanning 'PITRX_T_EMail' table...
Table: 'PITRX_T_EMail' (260195977); index ID: 0, database ID: 11
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.....................: 7978.0
- Avg. Page Density (full).....................: 1.43%
DBCC SHOWCONTIG scanning 'T_DAYS' table...
Table: 'T_DAYS' (373576369); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 27
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 6.8
- Scan Density [Best Count:Actual Count].......: 100.00% [4:4]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1643.7
- Avg. Page Density (full).....................: 79.69%
DBCC SHOWCONTIG scanning 'T_DATE_RANGE' table...
Table: 'T_DATE_RANGE' (389576426); index ID: 1, database ID: 11
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.....................: 6282.0
- Avg. Page Density (full).....................: 22.39%
DBCC SHOWCONTIG scanning 'DUAL' table...
Table: 'DUAL' (546100986); index ID: 0, database ID: 11
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.....................: 8082.0
- Avg. Page Density (full).....................: 0.15%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT' table...
Table: 'T_EQUIPMENT' (583673127); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 17
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 5.7
- Scan Density [Best Count:Actual Count].......: 100.00% [3:3]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1633.2
- Avg. Page Density (full).....................: 79.82%
DBCC SHOWCONTIG scanning 'T_ALARM_STATE' table...
Table: 'T_ALARM_STATE' (711673583); index ID: 1, database ID: 11
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.....................: 2068.5
- Avg. Page Density (full).....................: 74.44%
DBCC SHOWCONTIG scanning 'T_UNIT_CONVERSION' table...
Table: 'T_UNIT_CONVERSION' (789577851); index ID: 1, database ID: 11
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.....................: 3798.0
- Avg. Page Density (full).....................: 53.08%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_VARIABLE' table...
Table: 'T_EQUIPMENT_VARIABLE' (791673868); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 146
- Extents Scanned..............................: 19
- Extent Switches..............................: 18
- Avg. Pages per Extent........................: 7.7
- Scan Density [Best Count:Actual Count].......: 100.00% [19:19]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 21.05%
- Avg. Bytes Free per Page.....................: 1574.1
- Avg. Page Density (full).....................: 80.55%
DBCC SHOWCONTIG scanning 'T_ALARM_HISTORY' table...
Table: 'T_ALARM_HISTORY' (811149935); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 220
- Extents Scanned..............................: 28
- Extent Switches..............................: 27
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 100.00% [28:28]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1523.9
- Avg. Page Density (full).....................: 81.17%
DBCC SHOWCONTIG scanning 'T_ALARM_RULE' table...
Table: 'T_ALARM_RULE' (887674210); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 2226.5
- Avg. Page Density (full).....................: 72.49%
DBCC SHOWCONTIG scanning 'T_ASSET' table...
Table: 'T_ASSET' (1035150733); index ID: 0, database ID: 11
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.....................: 7911.0
- Avg. Page Density (full).....................: 2.26%
DBCC SHOWCONTIG scanning 'T_NET_EMPLOYEE_PERMISSION' table...
Table: 'T_NET_EMPLOYEE_PERMISSION' (1118627028); index ID: 0, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 9
- Extents Scanned..............................: 7
- Extent Switches..............................: 6
- Avg. Pages per Extent........................: 1.3
- Scan Density [Best Count:Actual Count].......: 28.57% [2:7]
- Extent Scan Fragmentation ...................: 57.14%
- Avg. Bytes Free per Page.....................: 6545.2
- Avg. Page Density (full).....................: 19.13%
DBCC SHOWCONTIG scanning 'T_NET_PERMISSION' table...
Table: 'T_NET_PERMISSION' (1150627142); index ID: 0, database ID: 11
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.....................: 7527.0
- Avg. Page Density (full).....................: 7.01%
DBCC SHOWCONTIG scanning 'T_NETWORK' table...
Table: 'T_NETWORK' (1243151474); index ID: 0, database ID: 11
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.....................: 7505.0
- Avg. Page Density (full).....................: 7.28%
DBCC SHOWCONTIG scanning 'T_COMPANY' table...
Table: 'T_COMPANY' (1262627541); index ID: 1, database ID: 11
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.....................: 5332.0
- Avg. Page Density (full).....................: 34.12%
DBCC SHOWCONTIG scanning 'T_OP_LOC_PARTNER' table...
Table: 'T_OP_LOC_PARTNER' (1294627655); index ID: 0, database ID: 11
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.....................: 7656.0
- Avg. Page Density (full).....................: 5.41%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_LOG_DATA' table...
Table: 'T_EQUIPMENT_LOG_DATA' (1303675692); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 29565
- Extents Scanned..............................: 3705
- Extent Switches..............................: 3704
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.76% [3696:3705]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.94%
- Avg. Bytes Free per Page.....................: 1550.7
- Avg. Page Density (full).....................: 80.84%
DBCC SHOWCONTIG scanning 'T_CONCURRENCY' table...
Table: 'T_CONCURRENCY' (1310627712); index ID: 0, database ID: 11
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.....................: 8078.0
- Avg. Page Density (full).....................: 0.20%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_FORMULA' table...
Table: 'T_EQUIPMENT_FORMULA' (1351675863); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 20
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 6.7
- Scan Density [Best Count:Actual Count].......: 100.00% [3:3]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1893.0
- Avg. Page Density (full).....................: 76.61%
DBCC SHOWCONTIG scanning 'T_APPLICATION_VARIABLE' table...
Table: 'T_APPLICATION_VARIABLE' (1394104007); index ID: 1, database ID: 11
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.....................: 7595.0
- Avg. Page Density (full).....................: 6.17%
DBCC SHOWCONTIG scanning 'T_CHK_EXCEPTION_INDEX' table...
Table: 'T_CHK_EXCEPTION_INDEX' (1426104121); index ID: 1, database ID: 11
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.....................: 3099.0
- Avg. Page Density (full).....................: 61.71%
DBCC SHOWCONTIG scanning 'T_DOWNTIME' table...
Table: 'T_DOWNTIME' (1522104463); index ID: 1, database ID: 11
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]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1994.8
- Avg. Page Density (full).....................: 75.36%
DBCC SHOWCONTIG scanning 'T_DOWNTIME_CODE' table...
Table: 'T_DOWNTIME_CODE' (1554104577); index ID: 1, database ID: 11
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.....................: 4371.0
- Avg. Page Density (full).....................: 46.00%
DBCC SHOWCONTIG scanning 'T_LOCATION' table...
Table: 'T_LOCATION' (1559676604); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2979.0
- Avg. Page Density (full).....................: 63.19%
DBCC SHOWCONTIG scanning 'T_DOWNTIME_TYPE' table...
Table: 'T_DOWNTIME_TYPE' (1586104691); index ID: 1, database ID: 11
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.....................: 7301.0
- Avg. Page Density (full).....................: 9.80%
DBCC SHOWCONTIG scanning 'T_NET_JOURNAL_TYPE' table...
Table: 'T_NET_JOURNAL_TYPE' (1639676889); index ID: 0, database ID: 11
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.....................: 7887.0
- Avg. Page Density (full).....................: 2.56%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_UNIT' table...
Table: 'T_EQUIPMENT_UNIT' (1687677060); index ID: 1, database ID: 11
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.....................: 1656.5
- Avg. Page Density (full).....................: 79.53%
DBCC SHOWCONTIG scanning 'T_EQUIPMENT_PROPERTY' table...
Table: 'T_EQUIPMENT_PROPERTY' (1714105147); index ID: 1, database ID: 11
TABLE level scan performed.
- Pages Scanned................................: 53
- Extents Scanned..............................: 7
- Extent Switches..............................: 6
- Avg. Pages per Extent........................: 7.6
- Scan Density [Best Count:Actual Count].......: 100.00% [7:7]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1557.4
- Avg. Page Density (full).....................: 80.76%
DBCC SHOWCONTIG scanning 'T_EQUIP_ATTRIBUTE_FILE' table...
Table: 'T_EQUIP_ATTRIBUTE_FILE' (1778105375); index ID: 1, database ID: 11
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 ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3895.5
- Avg. Page Density (full).....................: 51.87%
DBCC SHOWCONTIG scanning 'T_EQUIP_TYPE' table...
Table: 'T_EQUIP_TYPE' (1842105603); index ID: 1, database ID: 11
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.....................: 7983.0
- Avg. Page Density (full).....................: 1.37%
DBCC SHOWCONTIG scanning 'T_EQUIP_TYPE_PROPERTY' table...
Table: 'T_EQUIP_TYPE_PROPERTY' (1874105717); index ID: 1, database ID: 11
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.....................: 7117.0
- Avg. Page Density (full).....................: 12.07%
DBCC SHOWCONTIG scanning 'T_MODEL' table...
Table: 'T_MODEL' (1970106059); index ID: 1, database ID: 11
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.....................: 7866.0
- Avg. Page Density (full).....................: 2.82%
DBCC SHOWCONTIG scanning 'T_MODEL_TYPE' table...
Table: 'T_MODEL_TYPE' (2002106173); index ID: 1, database ID: 11
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.....................: 8017.0
- Avg. Page Density (full).....................: 0.95%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I can't restart the sql server at the moment, I will have to do that during off hours.
Go to Top of Page

AFTIadmin
Starting Member

22 Posts
Posted - 2006-06-27 : 11:30:22
Peso:
"How about physical defragmentation?"

For disk fragmentation we use a piece of software called diskkeeper which routinely defragments the drive when ever it is needed. Now I know this software does not affect query performance because we had this problem prior to installing diskkeeper.

And again, I moved the .ldf and .mdf files of the db to a new drive and still had these issues.

I'm going to try iperf and I'll let you guys know how it goes!
Thanks very much for all your help everyone.
Brian
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2006-06-27 : 11:49:19
quote:
Originally posted by AFTIadmin

Peso:
"How about physical defragmentation?"

For disk fragmentation we use a piece of software called diskkeeper which routinely defragments the drive when ever it is needed. Now I know this software does not affect query performance because we had this problem prior to installing diskkeeper.

And again, I moved the .ldf and .mdf files of the db to a new drive and still had these issues.

I'm going to try iperf and I'll let you guys know how it goes!
Thanks very much for all your help everyone.
Brian
What does CONTIG say? All in one fragment? I am using diskeeper too, but I am not very satisfied with database files.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site