Home » Microsoft TechnologiesRSS

Page Density Problems with SQL 2005 database

We have many files with an average page desity of about 25%.  We are having performance problems and I have read that this number should be closer to 75%.   I have been playing with maintanence plans to try to fix it but no luck. Does anyone know how I could fix this?  Thank you for your help.

We are using SQL2005 with SP3.

 

10 Answers Found

 

Answer 1

Ray,

You must be looking at DBCC SHOWCONTIG for this information. Maintenance plans will NOT help much as you can only do INDEXDEFRAG/REBUILD.

What you should be looking at why you are getting too many PAGE SPLITS? And take a look at your indexing best practices. Do you have GUIDs as PK in your tables? Or a non-sequential (other than an identity, ever increasing datetime values) as clustered PKs?

Other than that I can't think of anything else for now.

 

Answer 2

Thank you for the information.   I will take a look and see what I could find.  This is a third party piece of software that is having the problems.  Performance problems  are billable for them to fix, so I am not sure how much help they will be without paying them.  (We might have to do that.)

 

Here is what I got from DBCC SHOWCONTIG on one of the files with a problem.  I am not sure what I should be looking at.  Could you give me some guidence please. 

 

Table: 'ACCESSPROFPERM' (21575115); index ID: 1, database  ID: 22

TABLE level scan performed.

- Pages Scanned................................: 54

- Extents Scanned..............................: 13

- Extent Switches..............................: 12

- Avg. Pages per Extent........................: 4.2

- Scan Density [Best Count:Actual Count].......: 53.85% [7:13]

- Logical Scan Fragmentation ..................: 12.96%

- Extent Scan Fragmentation ...................: 61.54%

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

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

 

Answer 3

Don't worry about small tables, anything less than 1,000 pages is totally pointless, 8mb, and unless you have a very small server, anything below 1,000,000 pages, 8gb, is hardly going to matter.  OK, split the difference, maybe 10k to 50k pages, there might be some point to optimizations.  At least, worry about the biggest and busiest tables, first.

Josh

 

 

Answer 4

Ray,

 

Since you are in SQL Server 2005, you should start using sys.dm_db_index_physical_stats to look at the fragementation and other related information.

 

As Josh mentioned, fragmentation on small tables shouldn't be a big concern because small tables start out with single page  allocation until they have 3 extents of data. This will cause to high numbers of fragmentation [extent scan fragmentation].

 

Can you explain what kind of performance problems  are you facing? What is your hardware and environment like? If you can share this information with details then you might get good responses that might really help you troubleshoot them.

 

 

 

Answer 5

We are using payroll software for tracking employees time.  It consists of 2 servers.  One application server, and one SQL 2005 server.  One of the applications running is a timekeeping package.  We access it through internet explorer and something the pages load within a second, sometimes they take between 5-10 seconds, sometimes longer.  I have called support a few times and they have given me scripts to run on the SQL server because they believe that is the problem.  Basically here are a couple of things they said I should fix.

 

1)page density - Sorry my example above was a bad file to send.  We have 87 large files with this problem.  The report says index's with more that 1000 pages that are 5% or more below the 75% page  density.  Most of ours are right around 25%.  That is about all the info they could give me, they just say to correct the problem so the page density is close to 75%. 

2)Ensure the config_value, run_value for MAX DEGREE OF PARALLELISM is set to 1.  Our is currently set to 0.  I have not looked at this yet, I am not sure if this is a big change or not to make.

 

This is basically all the help their support could give.  I have just used SQL a little so I am not really sure what I need to do to fix number 1.  I was going to give it a shot to fix it, if I can’t our other option is to pay their support since any performance problem they bill for.

 

Thanks for your help.

Ray

 

 

 

 

Answer 6

Ray,

 

Let me explain what happens when you have low page  density. When you execute a query, sql  Server tries to load the table data from data files ( if the pages aren’t already in memory ) into buffer pool (memory). If the buffer pool is full then SQL Server will remove some table data that hasn’t been referenced recently from memory. The longer the page stays in memory, you will get better performance but if SQL Server has to fetch the data from disk then it will take sometime. On top of it, if the page density is low then you will likely to store less data in the pages and wasting disk space as well as valuable memory.

 

Sometimes, SQL Server can try to use parallel processing to process the certain queries while this is a good thing sometimes, there might be a possibility that there is some issue (like a missing index, bad statistics etc). Setting Maxdop to 1 means you are turning off parallelism and forcing SQL Server to use only one processor.

 

That being said, slow performance can be caused by a variety of reasons and the information you shared is NOT enough to give you solid advice.

 

I will ask you to run few queries and post the results back so that we will know more about your environment.

 

-- SQL Version information for current instance

SELECT@@VERSIONAS'Version Info';

 

-- Isolate top waits for server instance since last restart or statistics clear

WITH Waits AS

(SELECT wait_type, wait_time_ms / 1000. AS wait_time_s,

    100. * wait_time_ms /SUM(wait_time_ms)OVER()AS pct,

    ROW_NUMBER()OVER(ORDERBY wait_time_ms DESC)AS rn

 FROMsys.dm_os_wait_stats

 WHERE wait_type NOTIN('BROKER_TASK_STOP',

  'SQLTRACE_BUFFER_FLUSH','CLR_AUTO_EVENT','CLR_MANUAL_EVENT',

  'LAZYWRITER_SLEEP','SQLTRACE_WAIT_ENTRIES'))-- filter out additional irrelevant waits

SELECT W1.wait_type,

  CAST(W1.wait_time_s ASDECIMAL(12, 2))AS wait_time_s,

  CAST(W1.pct ASDECIMAL(12, 2))AS pct,

  CAST(SUM(W2.pct)ASDECIMAL(12, 2))AS running_pct

FROM Waits AS W1

INNERJOIN Waits AS W2

ON W2.rn <= W1.rn

GROUPBY W1.rn, W1.wait_type, W1.wait_time_s, W1.pct

HAVINGSUM(W2.pct)- W1.pct < 99;-- percentage threshold

 

-- Page Life Expectancy value

SELECT cntr_value AS'Page Life Expectancy'

FROMsys.dm_os_performance_counters

WHEREobject_name='SQLServer:Buffer Manager'

AND counter_name ='Page life expectancy';

 

-- Buffer Pool Usage

SELECTTOP(10) [type],sum(single_pages_kb)AS [SPA Mem, Kb]

FROMsys.dm_os_memory_clerks

GROUPBYtype 

ORDERBYSUM(single_pages_kb)DESC;

 

-- Switch to user database

--USE YourDatabaseName;

--GO

 

-- Individual File Sizes and space available for current database

SELECTnameAS'File Name', physical_name AS'Physical Name',size/128 AS'Total Size in MB',

size/128.0 -CAST(FILEPROPERTY(name,'SpaceUsed')ASint)/128.0 AS'Available Space In MB'FROMsys.database_files;

 

-- Missing Indexes for entire instance by Index Advantage

SELECT user_seeks * avg_total_user_cost *(avg_user_impact * 0.01)AS index_advantage, migs.last_user_seek,

mid.statement AS [Database.Schema.Table],

mid.equality_columns, mid.inequality_columns, mid.included_columns,

migs.unique_compiles, migs.user_seeks, migs.avg_total_user_cost, migs.avg_user_impact

FROMsys.dm_db_missing_index_group_statsAS migs WITH(NOLOCK)

INNERJOINsys.dm_db_missing_index_groupsAS mig WITH(NOLOCK)

ON migs.group_handle = mig.index_group_handle

INNERJOINsys.dm_db_missing_index_detailsAS mid WITH(NOLOCK)

ON mig.index_handle = mid.index_handle

ORDERBY index_advantage DESC;

 

All of these queries can be downloaded at http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!5538.entry

 

Answer 7

Ray,

Adding more details.

Based on the information you shared the problem may be parameter sniffing, blocking, bad statistics and many others.

You need to isolate the problem you are facing. Is it possible to narrow down the procedure thats causing the delay when using the application. YOu may need to look at the execution plan and the relevant tables to narrow down the problem.

 

Answer 8

thank you for the explanation of what is happening.  Let me see if I could get some help in narrowing down the problem.  In the meantime here is the output from the scripts if it help.

 

Version Info

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)

Nov 24 2008 13:01:59

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

 

(1 row(s) affected)

wait_type wait_time_s pct running_pct

------------------------------------------------------------ --------------------------------------- --------------------------------------- ---------------------------------------

WRITELOG 82532.14 20.76 20.76

PAGEIOLATCH_SH 58110.50 14.62 35.38

SLEEP_BPOOL_FLUSH 36672.61 9.22 44.60

CXPACKET 34359.52 8.64 53.24

BROKER_RECEIVE_WAITFOR 28574.44 7.19 60.43

ASYNC_NETWORK_IO 25335.42 6.37 66.80

PAGEIOLATCH_EX 25273.27 6.36 73.16

LCK_M_X 23357.66 5.88 79.03

OLEDB 17030.25 4.28 83.32

BACKUPIO 14506.80 3.65 86.97

SLEEP_TASK 12256.11 3.08 90.05

ASYNC_IO_COMPLETION 11159.91 2.81 92.86

BACKUPBUFFER 11030.77 2.77 95.63

LOGBUFFER 5257.95 1.32 96.95

LCK_M_SCH_M 3655.33 0.92 97.87

IO_COMPLETION 1957.41 0.49 98.36

BACKUPTHREAD 1244.59 0.31 98.68

SOS_SCHEDULER_YIELD 1108.55 0.28 98.96

PAGELATCH_SH 1103.41 0.28 99.23

(19 row(s) affected)

Page Life Expectancy

--------------------

683

(1 row(s) affected)

type SPA Mem, Kb

------------------------------------------------------------ --------------------

CACHESTORE_SQLCP 376248

USERSTORE_DBMETADATA 53704

CACHESTORE_OBJCP 44728

MEMORYCLERK_SOSNODE 23792

USERSTORE_SCHEMAMGR 19592

MEMORYCLERK_SQLGENERAL 11952

MEMORYCLERK_SQLSTORENG 9312

CACHESTORE_PHDR 6424

OBJECTSTORE_LOCK_MANAGER 4224

MEMORYCLERK_SQLOPTIMIZER 4192

(10 row(s) affected)

File Name Physical Name Total Size in MB Available Space In MB

-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------- ---------------------------------------

wfcdb F:\SQL\Databases\wfcdb.mdf 28 0.812500

wfcdb_log F:\SQL\Logs\wfcdb_log.ldf 36227 36161.648438

wfcdb_data_tkcs1 F:\SQL\Databases\wfcdb_data_tkcs1.ndf 1191 159.562500

wfcdb_data_tkcs2 F:\SQL\Databases\wfcdb_data_tkcs2.ndf 984 83.187500

wfcdb_data_tkcs3 F:\SQL\Databases\wfcdb_data_tkcs3.ndf 813 248.937500

wfcdb_data_tkcs4 F:\SQL\Databases\wfcdb_data_tkcs4.ndf 379 178.250000

wfcdb_data_tkcs5 F:\SQL\Databases\wfcdb_data_tkcs5.ndf 417 179.562500

wfcdb_data_tkcs6 F:\SQL\Databases\wfcdb_data_tkcs6.ndf 5 5.000000

wfcdb_data_tkcs7 F:\SQL\Databases\wfcdb_data_tkcs7.ndf 1082 164.250000

wfcdb_data_tkcs8 F:\SQL\Databases\wfcdb_data_tkcs8.ndf 1585 445.312500

wfcdb_data_tkcs9 F:\SQL\Databases\wfcdb_data_tkcs9.ndf 42 11.937500

(11 row(s) affected)

index_advantage last_user_seek Database.Schema.Table equality_columns inequality_columns included_columns unique_compiles user_seeks avg_total_user_cost avg_user_impact

 

 

Answer 9

38597.2159588852 2010-06-30 07:58:54.677 [wfcdb].[dbo].[WFCAUDIT] [EMPLOYEEID], [WFCAUDITTYPEID], [AUDITDTM] NULL [DATASOURCEID], [ENTEREDONDTM] 98 90338 0.459116034052218 93.06

13354.5677035541 2010-06-30 09:25:06.507 [wfcdb].[dbo].[WFAUNITSTR] [EMPLOYEEID] [EFFSTARTDTM], [EFFENDDTM] NULL 146 85071 0.165452609136372 94.88

10498.3429804721 2010-06-30 09:28:45.317 [wfcdb].[dbo].[WDMDEVFILES] [WDMFILESTATID], [WDMFILETYPEID] NULL [WDMDEVFILESID], [WDMDEVICEID], [PAYLOAD], [UPDATEDTM], [VERSIONCNT] 154 27627 0.463248815799753 82.03

8820.36670791427 2010-06-30 09:15:25.030 [wfcdb].[dbo].[WFAUNITSPAN] [WFAUNITID], [ENDDTM], [DELETEDSW] NULL [WFAUNITSPANID], [PARENTUNITSPANID], [WFAACTIVITYID], [STARTTIMEZONEID], [ENDTIMEZONEID], [STDSECSQTY], [STDQTY], [STDRATEAMT], [STDCOSTAMT], [WFAPUNCHID], [STARTDTM], [CREATEDDTM], [UPDATEDBYUSRACCTID], [UPDATEDTM], [VERSIONCNT] 89 4795 1.84669464465415 99.61

8820.36670791427 2010-06-30 09:15:25.030 [wfcdb].[dbo].[WFAUNITSPAN] [WFAUNITID], [ENDDTM], [DELETEDSW] NULL NULL 89 4795 1.84669464465415 99.61

7365.26087698774 2010-06-30 09:25:03.077 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlURL] [UseChangeLog], [ParentUpdateCrawlID] [CommitCrawlID] [DocID], [StartAddressID], [ProjectID], [HostDepth], [EnumerationDepth], [ParentDocID] 119250 29812 0.335265191016813 73.69

5447.13308011899 2010-06-30 09:28:43.600 [wfcdb].[dbo].[EMPGRPSCHEDMM] NULL [EFFECTIVEDTM], [EXPIRATIONDTM] [EMPLOYEEID], [GRPSCHEDULEID] 93 137727 0.0807312094163048 48.99

5418.35908958002 2010-06-30 09:17:18.227 [wfcdb].[dbo].[WFAUNITSTR] [PARENTID] [EMPLOYEEID], [EFFSTARTDTM], [EFFENDDTM] [WFAUNITSTR], [WFAUNITID] 80 34358 0.195443032581831 80.69

4981.81934409464 2010-06-30 09:13:46.780 [wfcdb].[dbo].[WFAREPACTYSPAN] [DELETEDSW], [PARENTUNITSPANID] NULL [EMPLOYEEID] 136 1732 4.80591330529426 59.85

4155.74621476103 2010-06-30 09:25:03.080 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlURL] [ProjectID] [CommitCrawlID] [HostID], [ErrorID] 651 44715 0.61103567752623 15.21

3961.53039378242 2010-06-30 09:25:01.707 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlURL] [StartAddressID] NULL [DocID], [TransactionFlags], [UseChangeLog], [ChangeLogCookie], [ErrorLevel], [LastTouchStart] 14920 14905 0.874293859748234 30.4

3815.66447006404 2010-06-30 09:25:01.737 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlURL] [StartAddressID] [SecurityUpdateErrorID] [DocID] 14920 14905 0.276188324600344 92.69

3717.13310558423 2010-06-30 09:25:01.730 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlURL] [StartAddressID], [CrawlID] NULL [DocID], [ProjectID], [TransactionFlags], [HostDepth], [EnumerationDepth], [ParentDocID], [CrawlScope] 14948 14905 0.330841513861623 75.38

3161.28599548151 2010-06-30 09:25:03.410 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlContent] [ContentSourceID] NULL [CrawlID] 59625 14905 0.428389562290319 49.51

2920.40579101169 2010-06-26 11:07:55.770 [wfcdb].[dbo].[WFAREPACTYSPAN] [DELETEDSW] NULL [EMPLOYEEID], [PARENTUNITSPANID] 11 157 26.3848379727306 70.5

2887.23114026426 2010-06-30 09:28:45.367 [wfcdb].[dbo].[WDMDEVTRXDATA] [WDMFILESTATID] NULL [WDMDEVTRXDATAID], [TRXDATATXT], [WDMTRXRECTYPEID], [UPDATEDTM], [VERSIONCNT] 139 27051 0.181302667105668 58.87

2766.37519244039 2010-06-30 09:24:43.603 [wfcdb].[dbo].[BATCHJOBTASK] [BATCHJOBID] NULL NULL 146 15947 0.190045003398389 91.28

1984.95323503044 2010-06-27 02:07:39.440 [wfcdb].[dbo].[TOTALEVENTTS] [TOTALIZATIONSTATUS], [EMPLOYEEINPROC_SW] NULL [PERSONID] 32 11643 0.184987726873029 92.16

1974.16398685481 2010-06-15 13:24:37.867 [Docushare].[dbo].[ACL_table] [Object_isDeleted] NULL [handle_id], [user_group_class], [user_group_index], [searcher], [reader] 4 204 13.2547246204173 73.01

1620.08299335997 2010-06-30 09:00:01.050 [VMware VirtualCenter].[dbo].[VPX_HIST_STAT1] [TIME_ID] NULL [COUNTER_ID], [STAT_VAL] 1006 3454 0.584261899131834 80.28

1361.73596627781 2010-06-30 09:25:05.483 [wfcdb].[dbo].[GROUPSHIFT] [DELETEDSW] [GRPSCHEDULEID], [SHIFTSTARTDATE], [SHIFTENDDATE] [GROUPSHIFTID], [SHIFTCODEID], [SHIFTTYPEID], [GRPPATTRNASGNID], [DATASOURCEID], [ENTEREDONDTM], [HASCOMMENTSW] 2966 14642 0.109517247523916 84.92

1258.60998712549 2010-06-30 09:16:34.140 [wfcdb].[dbo].[WFAUNITSPAN] [WFAUNITID], [WFAACTIVITYID], [ENDDTM], [DELETEDSW] NULL [WFAUNITSPANID], [PARENTUNITSPANID], [STARTTIMEZONEID], [ENDTIMEZONEID], [STDSECSQTY], [STDQTY], [STDRATEAMT], [STDCOSTAMT], [WFAPUNCHID], [STARTDTM], [CREATEDDTM], [UPDATEDBYUSRACCTID], [UPDATEDTM], [VERSIONCNT] 63 673 1.8772822417989 99.62

1258.60998712549 2010-06-30 09:16:34.140 [wfcdb].[dbo].[WFAUNITSPAN] [WFAUNITID], [WFAACTIVITYID], [ENDDTM], [DELETEDSW] NULL NULL 63 673 1.8772822417989 99.62

1073.85969541133 2010-06-30 09:17:18.287 [wfcdb].[dbo].[WFAUNITSTR] [PARENTID] [EFFSTARTDTM], [EFFENDDTM] [WFAUNITSTR], [WFAUNITID], [EMPLOYEEID] 170 6634 0.263721289895101 61.38

996.091940347352 2010-06-30 09:13:46.780 [wfcdb].[dbo].[WFAUNITSPAN] [DELETEDSW] [STARTDTM] [WFAUNITSPANID], [PARENTUNITSPANID], [WFAUNITID], [WFAACTIVITYID], [STARTTIMEZONEID], [ENDTIMEZONEID], [ENDDTM] 83 1282 3.00689935287402 25.84

774.87808656943 2010-06-30 08:43:46.543 [Docushare].[dbo].[ACL_table] [Object_isDeleted] [handle_id] [user_group_class], [user_group_index], [searcher], [reader] 53 125 9.52084885970733 65.11

765.128538927251 2010-06-30 09:22:16.843 [wfcdb].[dbo].[WFCEXCEPTION] NULL [EXCEPTIONTYPEID] [TIMESHEETITEMID], [MISSEDOUTDTM], [ISMARKEDSW] 385 1166 0.71912266634766 91.25

693.974478022276 2010-06-30 09:13:46.780 [wfcdb].[dbo].[WFAUNITSPAN] [WFAUNITID], [DELETEDSW] [STARTDTM] [WFAUNITSPANID], [PARENTUNITSPANID], [WFAACTIVITYID], [STARTTIMEZONEID], [ENDTIMEZONEID], [ENDDTM] 21 472 4.3294608688579 33.96

616.276057396151 2010-06-30 09:24:27.733 [wfcdb].[dbo].[KNXRUNHISTORY] [KNXRUNSTATUSCD] NULL [KNXRUNHISTORYID], [KNXINTERFACENM], [PERSONID], [REQUESTEDSTARTDTM], [KNXRUNAPPSERVER], [KNXRUNAPPSVRINST] 150 22302 0.0480076777718006 57.56

450.312083747917 2010-06-30 09:00:01.717 [VMware VirtualCenter].[dbo].[VPX_HIST_STAT2] [TIME_ID] NULL [COUNTER_ID], [STAT_VAL] 294 867 0.625320370882817 83.06

377.594718025192 2010-06-30 05:14:47.713 [BCF_DW].[DW].[DimItem] [Olivecode], [Containercode], [Sizecode], [Packcode] NULL NULL 2 979 0.399558995430712 96.53

364.097510317975 2010-06-30 05:36:02.020 [BCF_DW].[DW].[DimSales] [SetName] [InvoiceDate] [Numberofcases], [NetSale], [GrossPrice], [BaseCases], [ConvertedCases] 4 4 92.1765848906265 98.75

356.471430779485 2010-06-30 04:57:19.103 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW] [SHIFTSTARTDATE], [SHIFTENDDATE], [SHIFTTYPEID] [SHIFTASSIGNID], [DATASOURCEID], [ENTEREDONDTM], [SHIFTCODEID], [HASCOMMENTSW] 37 27048 0.13113647629182 10.05

350.52426264146 2010-06-30 04:57:19.103 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW], [SHIFTTYPEID] [SHIFTSTARTDATE], [SHIFTENDDATE] [SHIFTASSIGNID], [DATASOURCEID], [ENTEREDONDTM], [SHIFTCODEID] 36 26866 0.13125887860531 9.94

277.889160197009 2010-06-30 09:23:42.973 [wfcdb].[dbo].[PERSONSTATUSMM] [EMPLOYMENTSTATID] [PERSONID], [EFFECTIVEDTM], [EXPIRATIONDTM] NULL 1840 5887 0.339596159562661 13.9

272.370821299866 2010-06-30 05:36:20.083 [BCF_DW].[DW].[DimSales] [SetName] [SalesHistoryDate] [Broker1Amount], [Broker2Amount], [Numberofcases], [NetSale], [GrossPrice], [BaseCases], [ConvertedCases] 3 3 91.827929368486 98.87

259.659537636011 2010-06-21 14:11:15.840 [Docushare].[dbo].[DSObject_table] [handle_class], [Object_isDeleted] [handle_index] [Object_title], [Object_isRecord] 2 60 4.77877535401964 90.56

230.50627691688 2010-06-30 09:17:25.917 [wfcdb].[dbo].[WFCAUDIT] [EMPLOYEEID] NULL [DATASOURCEID], [WFCAUDITTYPEID], [ENTEREDONDTM], [AUDITDTM], [FROMDTM], [TODTM] 28 542 0.440804657747701 96.48

227.640863444981 2010-06-30 05:35:50.897 [BCF_DW].[ODS].[DailyLog] [StackLevel], [StepName] NULL [LogDate] 29 1065 0.219430540621805 97.41

214.387024992894 2010-06-29 12:01:25.513 [wfcdb].[dbo].[WATPOINTTRAN] [EXPPOINTTRANID] NULL NULL 22 2307 0.130591516077065 71.16

209.37368616444 2010-06-30 05:14:47.700 [BCF_DW].[DW].[DimItem] [Containercode] [Olivecode], [Sizecode], [Packcode] [PrimaryAlias] 1 531 0.408178806666667 96.6

207.798382524612 2010-06-30 05:14:47.707 [BCF_DW].[DW].[DimItem] [Containercode], [Sizecode] [Olivecode], [Packcode] [PrimaryAlias] 1 531 0.405191606666667 96.58

204.974598891554 2010-06-30 06:54:26.250 [wfcdb].[dbo].[WFAREPACTYSPAN] [EVENTDTM], [DELETEDSW] [EVENTTYPEID] [WFAREPACTYSPANID], [EMPLOYEEID] 27 31 7.04762719591922 93.82

204.268752309624 2010-06-30 05:14:47.660 [BCF_DW].[DW].[DimItem] NULL [Olivecode], [Containercode], [Sizecode], [Packcode] [PrimaryAlias] 1 531 0.411166006666667 93.56

189.348486287961 2010-06-30 09:16:38.657 [Docushare].[dbo].[ACL_table] NULL [handle_id] [user_group_class], [user_group_index], [searcher], [reader], [writer], [manager] 25 36 7.96679820458285 66.02

187.137176796787 2010-06-30 08:42:16.580 [wfcdb].[dbo].[WFCEXCEPTION] NULL [EXCEPTIONTYPEID] [WFCEXCEPTIONID], [TIMESHEETITEMID], [MISSEDOUTDTM], [ISMARKEDSW] 130 287 0.720572341898473 90.49

175.640823562922 2010-06-30 05:14:26.543 [BCF_DW].[DW].[DimItem] [Olivecode], [Containercode] [Sizecode], [Packcode] NULL 1 448 0.405938506666666 96.58

174.312222209365 2010-06-30 05:14:26.550 [BCF_DW].[DW].[DimItem] [Olivecode], [Containercode], [Sizecode] [Packcode] NULL 1 448 0.402951306666666 96.56

171.693208226475 2010-06-30 05:14:26.537 [BCF_DW].[DW].[DimItem] NULL [Olivecode], [Containercode], [Sizecode], [Packcode] [PrimaryAlias], [ShippingSize], [ShippingFactor] 1 448 0.411912906666667 93.04

171.051071271696 2010-06-30 06:56:36.333 [wfcdb].[dbo].[WFAUNITSTR] NULL [EFFSTARTDTM], [EFFENDDTM] [WFAUNITID], [PARENTID], [EMPLOYEEID] 176 1192 0.239245116481355 59.98

149.516455015268 2010-06-30 09:19:23.377 [wfcdb].[dbo].[COMBHOMEACCT] NULL [EFFECTIVEDTM], [EXPIRATIONDTM] [EMPLOYEEID], [LABORACCTID] 835 3003 0.343609588054614 14.49

140.125345752154 2010-06-30 06:56:36.487 [wfcdb].[dbo].[TIMESHEETITEM] [DELETEDSW], [TMSHTITEMTYPEID] [EMPLOYEEID], [EVENTDTM] [STARTPUNCHEVENTID], [ENDPUNCHEVENTID] 121 853 1.15685604867786 14.2

110.903327612768 2010-06-30 09:13:00.057 [wfcdb].[dbo].[IMPORTRESULT] NULL [IMPORTCNTNTTYPID] [IMPORTBTCHSTATID] 29 127 3.48604610032746 25.05

105.430683190602 2010-06-24 14:07:24.943 [wfcdb].[dbo].[WATPOINTTRAN] [EMPLOYEEID] [APPLYDTM], [POINTEXPIREDDTM] NULL 2 340 0.313951852463542 98.77

98.2045969575352 2010-06-30 09:23:42.973 [wfcdb].[dbo].[PERSONSTATUSMM] [USERACCTSTATID] [PERSONID], [EFFECTIVEDTM], [EXPIRATIONDTM] NULL 830 2127 0.359303295072379 12.85

96.0730859698116 2010-06-30 05:35:40.807 [DM_Sales].[dbo].[tblSalesandProj_Db4Cube] [SetName] NULL [Customernumber], [Sitenumber], [PrimaryAlias], [Broker1Amount], [Broker2Amount], [Numberofcases], [NetSale], [CostofSale], [Cost of Sale (w Adj)], [GrossPrice], [Gross Profit], [PromotionAllowance], [LabelAllowance], [Freight], [BillBacks], [SwellAllowanc 2 2 50.8000666084029 94.56

93.1510741928168 2010-06-30 05:29:26.433 [BCF_DW].[DW].[DimSales] [Broker1Surrogate] [SalesHistoryDate], [SetName] [SHSurrogate], [Broker1Amount], [InvoiceDate] 1 1 93.2069983918519 99.94

92.1457175219945 2010-06-30 05:39:05.863 [BCF_DW].[DW].[DimSales] [DivisionCompany], [SetName] [Productcode], [InvoiceDate] [PrimaryAlias], [Numberofcases], [WarehouseCode], [WeekOf] 1 1 95.6960406293431 96.29

91.8493178499754 2010-06-30 05:38:55.040 [BCF_DW].[DW].[DimSales] [DivisionCompany], [SetName] [SalesHistoryDate], [Productcode] [PrimaryAlias], [Numberofcases], [WarehouseCode], [WeekOf] 1 1 95.6963094915351 95.98

91.4213651081089 2010-06-30 05:38:40.460 [BCF_DW].[DW].[DimSales] [Productcode], [DivisionCompany], [SetName] [SalesHistoryDate] [PrimaryAlias], [WarehouseCode] 1 1 101.466553949066 90.1

90.9234269312515 2010-06-30 05:29:14.487 [BCF_DW].[DW].[DimSales] NULL [SalesHistoryDate], [Broker1Surrogate], [SetName] [SHSurrogate], [Broker1Amount], [InvoiceDate] 1 1 93.2069983918518 97.55

90.0030210027847 2010-06-30 05:25:21.683 [BCF_DW].[DW].[DimSales] [SetName] NULL [SalesKey] 1 1 204.134772063472 44.09

89.8450046942031 2010-06-30 05:38:52.267 [BCF_DW].[DW].[DimSales] [Productcode], [DivisionCompany], [SetName] NULL [PrimaryAlias], [WarehouseCode] 1 1 94.2858691302373 95.29

89.6369056053658 2010-06-30 05:35:51.640 [BCF_DW].[DW].[DimSales] [SetName] NULL [Broker1Amount], [Broker2Amount], [Numberofcases], [NetSale], [GrossPrice], [BaseCases] 1 1 90.5149001366917 99.03

89.5996444560908 2010-06-30 05:39:08.160 [BCF_DW].[DW].[DimSales] [DivisionCompany], [SetName] NULL [PrimaryAlias], [Numberofcases], [WarehouseCode], [WeekOf] 1 1 90.7705850026247 98.71

89.5922397026867 2010-06-30 05:39:04.283 [BCF_DW].[DW].[DimSales] [DivisionCompany], [SetName] NULL [PrimaryAlias], [Numberofcases], [WarehouseCode], [InvoiceDate] 1 1 92.287020707341 97.08

79.5714167405835 2010-06-24 06:33:17.447 [wfcdb].[dbo].[BATCHJOBTASKITM] [BATCHJOBTASKID] NULL [BATCHJOBTASKITMID], [ACTIONIDNUM], [BATCHACTIONTYPID], [ITEMNM], [ORDERNUM], [STATUSNUM], [STARTDTM], [ENDDTM], [COMMANDTXT], [ERRORTXT] 1 326 0.254519395653011 95.9

73.1741735386033 2010-06-24 06:33:17.447 [wfcdb].[dbo].[BATCHJOBTASKITM] [BATCHJOBTASKID] NULL NULL 1 326 0.254519395653011 88.19

65.0247065611579 2010-06-29 13:34:07.677 [wfcdb].[dbo].[WFCTOTAL] [EMPLOYEEID], [LABORACCTID] [APPLYDTM] [DURATIONSECSQTY], [MONEYAMT] 22 26 3.36511067324035 74.32

64.8226340122822 2010-06-30 05:28:39.417 [DM_Sales].[dbo].[tblSalesAndProj] NULL [SalesHistoryDate], [SetName] [Customernumber], [Sitenumber], [Servicetype], [PrimaryAlias], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [PrimaryBrokerSurrogate], [Salespersonnumb 1 1 101.206298223704 64.05

61.3971052381017 2010-06-30 09:25:03.410 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlURL] [ProjectID], [ErrorLevel] NULL [CommitCrawlID] 3558 890 0.59113548846174 11.67

59.9755020879623 2010-06-30 06:10:04.463 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [ACTENDDTM], [DELETEDSW] NULL NULL 34 357 0.304952995622454 55.09

58.6034352168696 2010-06-30 05:27:38.847 [BCF_DW].[DW].[DimSales] NULL [SetName] [SalesKey], [SalesHistoryDate], [Customernumber], [Sitenumber], [Servicetype], [PrimaryAlias], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [PrimaryBr 1 1 99.4458428930418 58.93

58.0559828065187 2010-06-30 05:25:44.807 [BCF_DW].[DW].[DimSales] [PrimaryAlias] [InvoiceDate] [Numberofcases] 1 1 606.645588364876 9.57

57.8645212064903 2010-06-30 05:26:15.637 [BCF_DW].[DW].[DimSales] NULL [SetName] [SalesKey], [SHSurrogate], [SalesHistoryDate], [Customernumber], [Sitenumber], [Servicetype], [PrimaryAlias], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amou 1 1 92.2731959918519 62.71

57.5967527770818 2010-06-30 09:28:31.133 [wfcdb].[dbo].[WORKEDSHIFT] [EMPLOYEEID], [NULLSHIFTSW] NULL [STARTAPPLYDTM], [ENDAPPLYDTM] 76 8490 0.018057146182119 37.57

57.5961517884127 2010-06-30 05:22:50.163 [BCF_DW].[DW].[DimSales] [SetName] NULL [SalesHistoryDate], [Customernumber], [Productcode], [NetSale], [ProductCategory], [BaseCases] 1 1 61.0193365699891 94.39

57.5449676549638 2010-06-30 05:22:51.880 [BCF_DW].[DW].[DimSales] [Productcode], [SetName] [NetSale] [SalesKey], [SalesHistoryDate], [Customernumber], [PrimaryAlias], [ProductCategory] 1 1 77.795008320892 73.97

56.4844643518362 2010-06-30 06:01:58.900 [wfcdb].[dbo].[WFAUNITSTR] [EMPLOYEEID] [EFFSTARTDTM], [EFFENDDTM] [WFAUNITID], [PARENTID] 58 494 0.229140322555379 49.9

55.3641515994795 2010-06-28 14:48:58.513 [wfcdb].[dbo].[GROUPSHIFT] [GRPSCHEDULEID], [DELETEDSW] [SHIFTSTARTDATE], [SHIFTENDDATE] [GROUPSHIFTID], [SHIFTCODEID], [SHIFTTYPEID], [GRPPATTRNASGNID], [DATASOURCEID], [ENTEREDONDTM], [HASCOMMENTSW] 51 571 0.101571323369008 95.46

51.9512604589819 2010-06-30 05:22:45.390 [BCF_DW].[DW].[DimSales] [SetName] NULL [SalesKey], [SHSurrogate], [SalesHistoryDate], [Customernumber], [Sitenumber], [Servicetype], [PrimaryAlias], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amou 1 1 104.677131692488 49.63

49.6069982256986 2010-06-30 05:38:40.460 [BCF_DW].[DW].[DimSales] [PrimaryAlias], [Productcode], [DivisionCompany], [SetName] [SalesHistoryDate] [WarehouseCode] 1 1 101.466553949066 48.89

48.6108454823658 2010-06-30 05:22:24.880 [BCF_DW].[DW].[DimSales] [SetName] NULL [PrimaryAlias], [Numberofcases], [WarehouseCode], [BaseCases], [InvoiceDate] 2 1 72.434578278 67.11

48.1491964193495 2010-06-24 14:07:24.937 [wfcdb].[dbo].[WATPOINTBAL] [EMPLOYEEID] NULL NULL 3 341 0.157483816082488 89.66

45.4535575880518 2010-06-30 05:35:41.180 [DM_Sales].[dbo].[tblSalesandProj_Db4Cube] NULL [SetName] [Customernumber], [Sitenumber], [PrimaryAlias], [Broker1Amount], [Broker2Amount], [Numberofcases], [NetSale], [CostofSale], [Cost of Sale (w Adj)], [GrossPrice], [Gross Profit], [PromotionAllowance], [LabelAllowance], [Freight], [BillBacks], [SwellAllowanc 1 1 51.8107347407407 87.73

40.9509056360617 2010-06-28 11:37:20.107 [wfcdb].[dbo].[WORKEDSHIFT] [EMPLOYEEID] [ENDAPPLYDTM] [WORKEDSHIFTID], [STARTAPPLYDTM], [UNSCHEDSTARTDTM], [UNSCHEDENDDTM], [UNSCHEDWORKRULEID], [NULLSHIFTSW] 20 9484 0.0270544729839557 15.96

40.0234132261824 2010-06-30 00:05:00.870 [VMware VirtualCenter].[dbo].[VPX_HIST_STAT3] [TIME_ID] NULL [COUNTER_ID], [STAT_VAL] 78 75 0.68459975584661 77.95

37.9625419464805 2010-06-30 09:15:09.713 [wfcdb].[dbo].[EMPGRPSCHEDMM] NULL [EMPLOYEEID] [EMPGRPSCHEDMMID], [GRPSCHEDULEID], [EFFECTIVEDTM], [EXPIRATIONDTM] 223 461 0.120041176636164 68.6

33.5926903948612 2010-06-30 05:36:27.377 [BCF_DW].[ODS].[DailyLog] [StepName], [LogDate] NULL NULL 348 159 0.24626970784196 85.79

33.4685726905034 2010-06-23 09:22:46.277 [wfcdb].[dbo].[ACCSCONTRPOINT] [INACTIVESW] NULL [ACCSCONTRPOINTID], [VISIBLESW] 249 817 0.266874301312926 15.35

33.0136494811478 2010-06-29 21:05:33.040 [wfcdb].[dbo].[WFAPUNCH] [SERVERNM], [PUNCHSTATTYPEID] [UPDATEDTM] [WFAPUNCHID] 7 7 4.80708963425132 98.11

32.2512008626845 2010-06-29 16:16:04.503 [wfcdb].[dbo].[WFAACTIVITY] [ACTYLEVELCNT] [SEARCHNM] [WFAACTIVITYID], [ACTIVITYNM], [ACTIVITYDSC], [ACTSTARTDTM], [ACTCOMPLDTM], [COMPLSTATTYPEID], [HELDSTATTYPEID] 2 306 0.142350190776071 74.04

29.0055679977184 2010-06-22 09:17:03.410 [wfcdb].[dbo].[WFAREPTOTAL] NULL [APPLYDTM] [WFAREPACTYSPANID], [EMPLOYEEID], [ADJSTARTDTM], [ADJENDDTM], [SECSQTY] 1 1 36.6324425331124 79.18

28.821741075688 2010-06-30 09:25:03.430 [WSS_Search_SPSVR01_new].[dbo].[MSSCrawlDeletedURL] [ProjectID], [ErrorLevel] NULL [CrawlID] 2473 619 0.154587579009154 30.12

28.0362762935509 2010-06-24 08:59:17.413 [wfcdb].[dbo].[MGRAPPROVAL] [PERSONID] [APPROVALDTM] [MANAGERID], [ENTEREDONDTM] 4 4997 0.0360811680494481 15.55

25.5588513421031 2010-06-30 08:29:33.180 [wfcdb].[dbo].[PERSONSTATUSMM] [PROCESSEDSW] [EFFECTIVEDTM] [PERSONID] 122 608 0.0613687364149614 68.5

22.8956753612071 2010-06-29 09:07:12.330 [wfcdb].[dbo].[LABORACCT] [LABORLEV4NM], [LABORLEV7NM] NULL NULL 89 600 0.340709454779867 11.2

22.2168582806666 2010-06-30 09:23:43.197 [wfcdb].[dbo].[PERSONSTATUSMM] [EMPLOYMENTSTATID] NULL [PERSONID] 219 492 0.282050068817084 16.01

20.4770585356683 2010-06-30 05:39:10.650 [BCF_DW].[DW].[DimOrders] [OrderType], [DivisionCompany] [OrderStatusCode], [TransferWarehouseCode] [ExpectedArrivalDate], [NumberOfCases], [PrimaryAlias] 1 1 20.9205747197265 97.88

20.1604493139576 2010-06-30 05:39:08.453 [BCF_DW].[DW].[DimOrders] [OrderType], [DivisionCompany] [OrderStatusCode], [TransferWarehouseCode] [ExpectedArrivalDate], [ShippedCases], [PrimaryAlias] 1 1 20.5992125410827 97.87

20.0097859217192 2010-06-30 08:49:20.407 [webroot].[dbo].[Detections] [EventID] NULL [spyTag] 29 137 0.233990438233572 62.42

19.1730563534998 2010-06-30 05:38:38.250 [BCF_DW].[DW].[DimOrders] [OrderType], [DivisionCompany] [OrderStatusCode], [TransferWarehouseCode] [PrimaryAlias] 1 1 19.8089227745632 96.79

18.1774899065441 2010-06-30 09:16:08.997 [WSS_Content].[dbo].[AllUserData] [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DirName], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] NULL NULL 14 80 1.42814974124325 15.91

16.5544571145379 2010-06-30 05:19:50.150 [BCF_DW].[ODS].[Sales_A0CYREP] NULL [Customernumber], [PrimaryAlias], [Broker2Surrogate] [SHSurrogate], [SalesHistoryDate], [Sitenumber], [Servicetype], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Amount], [Broker2Amount], [Broker3Amount], [Broker4Amount], [Broker5Amount], [PrimaryBrokerSurrogate], [Sal 1 1 26.9221940389298 61.49

16.4811747073628 2010-06-30 05:20:09.817 [BCF_DW].[ODS].[Sales_A0CYREP] NULL [Customernumber], [PrimaryAlias], [Broker3Surrogate] [SHSurrogate], [SalesHistoryDate], [Sitenumber], [Servicetype], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [Broker3Amount], [Broker4Amount], [Broker5Amount], [PrimaryBr 1 1 26.168902361643 62.98

16.4805553198432 2010-06-30 05:20:11.560 [BCF_DW].[ODS].[Sales_A0CYREP] NULL [Customernumber], [PrimaryAlias], [Broker4Surrogate] [SHSurrogate], [SalesHistoryDate], [Sitenumber], [Servicetype], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [Broker3Amount], [Broker4Amount], [Broker5Amount], [PrimaryBr 1 1 23.0852434792593 71.39

16.4800531756677 2010-06-30 05:36:27.377 [BCF_DW].[ODS].[DailyLog] [StepName], [LogDate] NULL [EndETLStamp], [Duration] 174 78 0.247868058448359 85.24

16.357693500431 2010-06-30 05:17:09.143 [BCF_DW].[ODS].[Sales_A0CYREP] NULL [Customernumber], [PrimaryAlias] [SHSurrogate], [SalesHistoryDate], [Sitenumber], [Servicetype], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [Broker3Amount], [Broker4Amount], [Broker 1 1 35.2232848846489 46.44

16.1905920308063 2010-06-30 09:16:08.997 [WSS_Content].[dbo].[AllDocs] [SiteId], [DirName], [DeleteTransactionId], [IsCurrentVersion] NULL NULL 20 115 1.00634565253481 13.99

16.1886631302145 2010-06-30 09:06:38.630 [wfcdb].[dbo].[PERSONSTATUSMM] NULL [PERSONID] [EMPLOYMENTSTATID], [USERACCTSTATID], [EFFECTIVEDTM], [EXPIRATIONDTM] 256 357 0.316664771806772 14.32

15.3267009994297 2010-06-29 21:04:37.137 [wfcdb].[dbo].[PERSONSTATUSMM] [EMPLOYMENTSTATID] [EFFECTIVEDTM], [EXPIRATIONDTM] [PERSONID] 104 318 0.290169614414096 16.61

13.6865694873647 2010-06-26 10:51:22.060 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [DELETEDSW] [EVENTDTM], [EVENTTYPEID] [WFAREPACTYSPANID], [ALLOCATEDSECSQTY] 7 7 4.23850902337019 46.13

11.6144294893106 2010-06-30 05:26:07.763 [BCF_DW].[ODS].[DailyLog] [StepName], [LogDate] NULL [StartETLStamp] 116 55 0.247737500305246 85.24

11.4795606710521 2010-06-30 08:58:44.310 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW], [SHIFTTYPEID] [SHIFTSTARTDATE], [SHIFTENDDATE] [SHIFTASSIGNID], [SHIFTCODEID], [GROUPSHIFTID] 19 313 0.0553682256749206 66.24

11.235692569589 2010-06-30 01:27:00.880 [wfcdb].[dbo].[BATCHJOB] NULL [LAUNCHDTM] [BATCHJOBID] 79 77 0.739949722714694 19.72

9.63838083462275 2010-06-30 06:56:36.307 [wfcdb].[dbo].[LABORACCT] [LABORLEV7NM] [LABORLEV4NM] [LABORACCTID] 86 250 0.33997815995142 11.34

9.06753604552124 2010-06-30 05:38:17.467 [DW Sales DB4Cube].[dbo].[tblSales] NULL [InvoiceDate] [Customernumber], [Sitenumber], [PrimaryAlias], [Broker1Amount], [Broker2Amount], [Numberofcases], [NetSale], [CostofSale], [Cost of Sale (w Adj)], [GrossPrice], [Gross Profit], [PromotionAllowance], [LabelAllowance], [Freight], [BillBacks], [SwellAllowanc 2 2 6.76177184602628 67.05

8.76503843321031 2010-06-30 00:21:19.133 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID] [EVENTDTM] [WFAREPACTYSPANID], [WFAACTIVITYID] 11 49 0.620674307326991 28.82

8.66821581747306 2010-06-30 05:21:43.350 [BCF_DW].[ODS].[ProjectionsWS_A0CYPRJ] NULL [Customernumber], [PrimaryAlias] [SHSurrogate], [SalesHistoryDate], [Sitenumber], [Servicetype], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [Broker3Amount], [Broker4Amount], [Broker 1 1 66.5250638332545 13.03

8.60612404489651 2010-06-22 10:31:13.040 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [DELETEDSW] [EVENTDTM], [EVENTTYPEID] [WFAREPACTYSPANID] 9 9 2.16981167458248 44.07

8.58614208035481 2010-06-23 09:22:46.420 [wfcdb].[dbo].[PRSNACCSASSIGN] [ACCESSPROFID] NULL NULL 101 325 0.030300377002849 87.19

8.49349276697446 2010-06-30 08:37:50.903 [wfcdb].[dbo].[WATTRANSACTION] [HASACTIONSW] NULL [WATTRANSACTIONID], [EMPLOYEEID] 10 16 0.894579201105332 59.34

8.32906349537702 2010-06-30 05:35:51.617 [DM_Sales].[dbo].[tblSpclChrgs] NULL [Charge Group], [SHD as Date] [Extended value] 2 2 4.61290623359383 90.28

8.13902797782608 2010-06-30 09:15:09.560 [wfcdb].[dbo].[HOMEACCTHIST] NULL [EMPLOYEEID] [HOMEACCTHISTID], [LABORACCTID], [EFFECTIVEDTM], [EXPIRATIONDTM], [VERSIONCNT], [PRIMARYORGIDSID] 68 85 0.117980865361466 81.16

7.7712964169903 2010-06-24 16:36:34.253 [wfcdb].[dbo].[WFCEXCEPTION] NULL [EXCEPTIONTYPEID] [TIMESHEETITEMID], [INPUNCHSW], [ISMARKEDSW] 2 4 2.29920012336991 84.5

7.57442022633504 2010-06-26 07:51:32.613 [wfcdb].[dbo].[TIMESHEETITEM] [ENDPUNCHEVENTID], [DELETEDSW], [TMSHTITEMTYPEID] [EMPLOYEEID], [EVENTDTM] NULL 22 166 0.492222626839724 9.27

7.40063613599767 2010-06-30 05:20:50.480 [BCF_DW].[ODS].[ProjectionsP2_A0CYPRJ] NULL [Customernumber], [PrimaryAlias] [SHSurrogate], [SalesHistoryDate], [Sitenumber], [Servicetype], [Productcode], [OliveCode], [ContCode], [SizeCode], [Labelcode], [Packcode], [Broker1Surrogate], [Broker1Amount], [Broker2Surrogate], [Broker2Amount], [Broker3Amount], [Broker4Amount], [Broker 1 1 64.8041693169673 11.42

7.25709865214275 2010-06-30 05:36:26.630 [DW Sales DB4Cube].[dbo].[tblSales] [SetName] [InvoiceDate] [Broker1Amount], [Broker2Amount], [Numberofcases], [NetSale], [GrossPrice], [PromotionAllowance], [LabelAllowance], [BillBacks], [SwellAllowance], [BaseCases], [ConvertedCases] 2 2 6.67135378943073 54.39

6.89430905804642 2010-06-30 08:42:16.497 [wfcdb].[dbo].[PERSONSTATUSMM] [EMPLOYMENTSTATID] [PERSONID] NULL 45 244 0.18276432724446 15.46

6.76611162218068 2010-06-22 10:30:35.337 [wfcdb].[dbo].[WFAREPACTYSPAN] [EVENTDTM], [DELETEDSW] [EVENTTYPEID] [WFAREPACTYSPANID], [EMPLOYEEID], [ALLOCATEDSECSQTY] 1 1 7.4011284425516 91.42

6.60075488686073 2010-06-29 08:11:16.693 [wfcdb].[dbo].[WFAREPACTYSPAN] [DELETEDSW], [PARENTUNITSPANID] NULL [WFAREPACTYSPANID], [EMPLOYEEID], [EVENTDTM], [DATASOURCEID], [WFAACTIVITYID], [INSERTEDDTM], [ACTSTARTDTM], [ACTENDDTM], [ADJSTARTDTM], [ADJENDDTM], [STARTTIMEZONEID], [ENDTIMEZONEID], [EVENTTIMEZONEID], [HRSALLOCTYPEID], [WEIGHTVALUEAMT], [WFATRANSID], [ 1 25 0.270855760642623 97.48

5.696902161378 2010-06-30 01:27:00.960 [wfcdb].[dbo].[BATCHJOBTASKITM] [BATCHACTIONTYPID], [STATUSNUM] NULL [BATCHJOBTASKITMID], [ACTIONIDNUM] 28 26 0.241765002307692 90.63

5.63045389240009 2010-06-30 01:27:00.583 [wfcdb].[dbo].[BATCHJOBTASKITM] [BATCHACTIONTYPID], [STATUSNUM] NULL [BATCHJOBTASKID], [ACTIONIDNUM] 34 26 0.276961144568954 78.19

5.61355189649966 2010-06-28 07:59:57.207 [wfcdb].[dbo].[TIMESHEETITEM] [ENDPUNCHEVENTID], [DELETEDSW], [TMSHTITEMTYPEID] [EVENTDTM] NULL 6 12 4.4509609074688 10.51

5.27217128249466 2010-06-30 09:11:41.510 [wfcdb].[dbo].[COMBHOMEACCT] NULL [EFFECTIVEDTM], [EXPIRATIONDTM] [EMPLOYEEID] 61 105 0.309945401675171 16.2

5.04368101026192 2010-06-29 14:27:08.597 [cats].[dbo].[isl] [contactno], [seq] NULL [icode], [scode] 33 40 0.167363983616337 75.34

4.70677869618855 2010-06-30 02:35:00.027 [webroot].[dbo].[Events] [EventTypeID] NULL [EventID], [OccuredTimestamp] 26 26 0.534484646747582 33.87

4.62213765431803 2010-06-30 01:27:00.433 [wfcdb].[dbo].[BATCHJOBTASKITM] [ACTIONIDNUM], [BATCHACTIONTYPID] NULL NULL 26 26 0.186131845006887 95.51

4.61645079088821 2010-06-30 02:35:00.027 [webroot].[dbo].[Detections] [EventID] NULL [DetectionID] 26 26 0.534484646747582 33.22

4.48260334401767 2010-06-29 14:55:39.607 [cats].[dbo].[isl] [contactno], [seq] NULL NULL 26 36 0.181776291322695 68.5

4.42337356394562 2010-06-22 10:31:40.607 [wfcdb].[dbo].[WFAREPACTYRES] [WFAMAPID], [DELETEDSW] NULL [WFAREPACTYSPANID], [REPTXT] 2 2 20.9440036171668 10.56

4.08019981246951 2010-06-28 14:44:35.343 [msdb].[dbo].[backupset] [type], [database_name] NULL [backup_finish_date] 16 16 0.55102093405217 46.28

3.89420895851788 2010-06-30 05:14:08.480 [BCF_DW].[DW].[DimItemListsResolved] [ListCode] NULL [ItemMasterSurrogate] 6 3 2.65943383085288 48.81

3.79129556097029 2010-06-26 07:51:32.613 [wfcdb].[dbo].[TIMESHEETITEM] [STARTPUNCHEVENTID], [DELETEDSW], [TMSHTITEMTYPEID] [EMPLOYEEID], [EVENTDTM] NULL 11 83 0.492222626839724 9.28

3.78312466536475 2010-06-26 07:51:32.613 [wfcdb].[dbo].[TIMESHEETITEM] [STARTPUNCHEVENTID], [ENDPUNCHEVENTID], [DELETEDSW], [TMSHTITEMTYPEID] [EMPLOYEEID], [EVENTDTM] NULL 11 83 0.492222626839724 9.26

3.73301790790872 2010-06-29 14:55:39.607 [cats].[dbo].[isl] [seq] NULL [contactno] 30 40 0.193300430194113 48.28

3.5588405720861 2010-06-25 11:33:40.680 [wfcdb].[dbo].[LABORACCT] NULL [LABORLEV1ID] [LABORACCTID], [LABORLEV2ID], [LABORLEV3ID], [LABORLEV4ID], [LABORLEV5ID], [LABORLEV6ID], [LABORLEV7ID], [LABORLEV1NM], [LABORLEV2NM], [LABORLEV3NM], [LABORLEV4NM], [LABORLEV5NM], [LABORLEV6NM], [LABORLEV7NM] 9 37 0.646403765636099 14.88

3.32518762648937 2010-06-29 14:27:08.597 [cats].[dbo].[isl] [seq] NULL [icode], [scode], [contactno] 33 40 0.167363983616337 49.67

3.0260971895271 2010-06-26 10:51:22.260 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [ORPHANEDSW], [DELETEDSW] [EVENTDTM], [EVENTTYPEID] [WFAREPACTYSPANID], [WFAACTIVITYID], [STDQTY], [DIRECTSW], [STDSECSQTY], [ALLOCATEDSECSQTY] 1 1 4.29416374276586 70.47

2.81211710133879 2010-06-28 07:59:57.207 [wfcdb].[dbo].[TIMESHEETITEM] [STARTPUNCHEVENTID], [DELETEDSW], [TMSHTITEMTYPEID] [EVENTDTM] NULL 3 6 4.4509609074688 10.53

2.80410537170535 2010-06-28 07:59:57.207 [wfcdb].[dbo].[TIMESHEETITEM] [STARTPUNCHEVENTID], [ENDPUNCHEVENTID], [DELETEDSW], [TMSHTITEMTYPEID] [EVENTDTM] NULL 3 6 4.4509609074688 10.5

2.7792545420383 2010-06-29 23:33:40.970 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [WFAACTIVITYID], [ACTENDDTM], [DELETEDSW] [EVENTTYPEID] NULL 11 181 0.0202733000657841 75.74

2.68368975787556 2010-06-29 11:59:22.430 [wfcdb].[dbo].[WATTRANSACTION] [WATEVENTID], [HASPOINTCHANGESW] NULL NULL 4 5 0.540630491111111 99.28

2.557564561296 2010-06-29 16:16:04.503 [wfcdb].[dbo].[WFAACTIVITY] [ACTYLEVELCNT] [SEARCHNM] NULL 2 306 0.0133429982788671 62.64

2.52773961729497 2010-06-28 05:00:00.117 [wfcdb].[dbo].[WTKEMPLOYEE] [TIMEZONEID] NULL [EMPLOYEEID] 14 268 0.0390715171650287 24.14

2.52268711514249 2010-06-30 09:18:37.183 [wfcdb].[dbo].[BASEWAGERTHIST] NULL [EMPLOYEEID], [EFFECTIVEDTM], [EXPIRATIONDTM] [BASEWAGEHOURLYAMT] 72 76 0.318859284486386 10.41

2.29527445699403 2010-06-21 09:56:02.523 [wfcdb].[dbo].[WTKEMPLOYEE] NULL [EMPLOYEEID] [PERSONID] 8 48 0.103682172276761 46.12

2.15782397747275 2010-06-30 09:18:37.183 [wfcdb].[dbo].[WTKEMPLOYEE] NULL [PAYRULEID], [EMPLOYEEID] [WTKEMPLOYEEID], [TIMEZONEID], [SUPERVISORID], [WORKERTYPEID] 68 72 0.319848212005328 9.37

2.00031546327378 2010-06-24 07:52:45.167 [wfcdb].[dbo].[WFCEXCEPTION] [EXCEPTIONTYPEID] [MISSEDOUTDTM] [TIMESHEETITEMID] 3 3 6.63454548349511 10.05

1.92816863209892 2010-06-27 01:27:06.137 [wfcdb].[dbo].[WDMDEVFILES] NULL [WDMFILESTATID], [UPDATEDTM] [WDMDEVFILESID] 4 4 1.47729745027499 32.63

1.89723697981136 2010-06-29 11:33:19.643 [WSS_Content].[dbo].[AllDocs] [SiteId], [ListId], [Type] [DirName], [DeleteTransactionId] NULL 2 30 0.0805107990584069 78.55

1.84268926812696 2010-06-30 02:35:00.027 [webroot].[dbo].[Traces] [DetectionID] NULL [TraceID] 26 26 0.534484646747582 13.26

1.82771878121505 2010-06-29 21:04:31.550 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [PRODUCTSHORTNM], [TABLENM] 7 7 0.941249758582268 27.74

1.82244778256699 2010-06-29 21:04:31.550 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [PRODUCTSHORTNM], [TABLENM], [PARENTTABLENM] 7 7 0.941249758582268 27.66

1.81123947849223 2010-06-28 13:14:34.530 [wfcdb].[dbo].[WDMDEVICEUPDATE] [WDMDEVICEID], [TERMINALRULEID], [UPDATEEMPLOYEESW] NULL [EMPLOYEEID], [BADGENUM] 39 139 0.0653157886980844 19.95

1.76710229676235 2010-06-29 21:04:31.550 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [TABLENM] NULL [NAME], [PRODUCTSHORTNM] 7 7 0.941249758582268 26.82

1.70105075625676 2010-06-30 05:35:50.937 [BCF_DW].[DW].[DimInvMonthEnds] [MonthEndDate] NULL [MonthEndInvBal], [MonthEndInTransit] 1 1 2.9303199935517 58.05

1.65171127944648 2010-06-29 13:39:03.720 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW], [LOCKEDSW] [SHIFTSTARTDATE] [SHIFTENDDATE], [GROUPSHIFTID] 9 123 0.0715426051538079 18.77

1.62132680343223 2010-06-29 13:39:03.713 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW] [SHIFTSTARTDATE], [GROUPSHIFTID] [LOCKEDSW], [SHIFTENDDATE] 9 123 0.0413084259702015 31.91

1.52459434599792 2010-06-10 12:09:56.003 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD] NULL [PARENTOBJECTNM], [COLUMNNM], [COLUMNORDERNUM] 8 8 0.816863665879728 23.33

1.45539960043118 2010-06-29 12:54:56.460 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [EVENTDTM], [DELETEDSW] [EVENTTYPEID] [WFAREPACTYSPANID] 24 28 0.127242489983492 40.85

1.45208319259365 2010-06-30 05:02:12.637 [BCF_DW].[ODS].[CostPlanDtl_A0DVREP] NULL [FiscalYear] NULL 1 1 5.48162775611043 26.49

1.41275714136582 2010-06-29 14:28:55.813 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [tp_CalculatedVersion] NULL NULL 9 31 0.294969650561817 15.45

1.39738463425205 2010-06-24 12:46:49.887 [wfcdb].[dbo].[WFAUNITSTR] [PARENTID] [EMPLOYEEID], [EFFSTARTDTM], [EFFENDDTM] NULL 4 8 0.335393777422247 52.08

1.34718999101547 2010-06-30 08:37:50.713 [wfcdb].[dbo].[WATPOINTBAL] NULL [WATTRANSTATUSID] [EMPLOYEEID], [WATPOINTTYPEID], [POINTSTARTBALAMT], [POINTENDBALAMT], [STARTDTM], [ENDDTM] 10 16 0.441065345408418 19.09

1.31486018282727 2010-06-30 05:14:49.257 [BCF_DW].[DW].[DimItemListPrice] [EndDate] [ChangeDate] [PrimaryAlias] 27 28 0.0923304998895614 50.86

1.24387042041248 2010-06-30 09:02:28.083 [wfcdb].[dbo].[PERSONSTATUSMM] NULL [PERSONID], [EFFECTIVEDTM], [EXPIRATIONDTM] [EMPLOYMENTSTATID], [USERACCTSTATID] 21 27 0.282114359033019 16.33

1.21167081422295 2010-06-29 21:04:31.550 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [PARENTTABLENM] NULL [NAME], [PRODUCTSHORTNM], [TABLENM] 7 7 0.941249758582268 18.39

1.06706139685938 2010-06-10 12:09:55.660 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [CLUSTEREDINDEXSW] NULL [NAME] 4 4 0.855291276738846 31.19

1.05520822967797 2010-06-30 05:35:50.937 [BCF_DW].[DW].[DimInvMonthEnds] NULL [MonthEndDate] NULL 1 1 2.9303199935517 36.01

1.04042722928401 2010-06-28 20:02:29.213 [msdb].[dbo].[backupset] [type], [database_name], [server_name], [is_copy_only] [backup_start_date] [backup_set_id] 4 4 0.27615119155006 94.19

1.038494103824 2010-06-28 20:02:29.220 [msdb].[dbo].[backupset] [database_name], [server_name] [backup_start_date], [type] [backup_set_id] 4 4 0.274240547117354 94.67

1.03556877862378 2010-06-10 12:09:55.683 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [CLUSTEREDINDEXSW] NULL [NAME], [TABLENM] 4 4 1.03103223678194 25.11

1.01396724353489 2010-06-30 05:16:14.763 [BCF_DW].[DW].[DimItem] [Productcode] NULL [PrimaryAlias] 2 2 3.5677946640918 14.21

0.973482649337249 2010-06-30 08:00:07.547 [WSS_Content].[dbo].[AllUserData] [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_ID], [tp_DirName] NULL 3 4 2.36972407336234 10.27

0.940145554228547 2010-06-28 18:17:51.293 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [ACTENDDTM], [DELETEDSW] [ACTSTARTDTM], [EVENTTYPEID] NULL 7 7 0.138218079393779 97.17

0.936196911138368 2010-06-30 05:14:50.553 [BCF_DW].[ODS].[CostPlanDtl_A0DVREP] [Attribute5] NULL [Surrogate], [Attribute1], [Attribute2], [Attribute3], [Attribute4] 1 1 2.5447048413655 36.79

0.857134500567704 2010-06-21 16:26:18.750 [BELLCAR3].[dbo].[EMSH_SAL_JOB_HISTORY] [SUPERVISOR_NUMBER] NULL [EMP_NUMBER], [ACTION_DATE], [SEQ_NUMBER] 2 2 0.457089644074074 93.76

0.816470297377146 2010-06-28 15:59:36.957 [msdb].[dbo].[backupset] [media_set_id] NULL NULL 3 3 0.462065816285878 58.9

0.804420224223709 2010-06-29 21:04:37.137 [wfcdb].[dbo].[TOTALEVENTTS] [TOTALIZATIONSTATUS] NULL [PERSONID], [ACTUALTOTALEND_DTM], [SCHEDULETTLEND_DTM] 28 28 0.242441297234391 11.85

0.767706010937488 2010-06-29 13:03:38.770 [wfcdb].[dbo].[EMPGRPSCHEDMM] NULL [EMPLOYEEID] [GRPSCHEDULEID], [EFFECTIVEDTM], [EXPIRATIONDTM] 9 10 0.240283571498431 31.95

0.715423578788322 2010-06-27 01:27:02.263 [wfcdb].[dbo].[WDMDEVTRXDATA] NULL [WDMFILESTATID], [UPDATEDTM] [WDMDEVTRXDATAID] 4 4 0.539860835185875 33.13

0.698201802047007 2010-06-29 11:33:19.630 [WSS_Content].[dbo].[ContentTypeUsage] [SiteId], [WebId], [ListId], [IsFieldId] NULL NULL 1 4 0.201443105033759 86.65

0.694753512538238 2010-06-25 14:22:01.077 [cats].[dbo].[contact] [date_chgd] NULL NULL 1 8 0.251722287151536 34.5

0.635720476821011 2010-06-29 14:07:27.863 [wfcdb].[dbo].[PERSONSTATUSMM] NULL [EMPLOYMENTSTATID], [EFFECTIVEDTM], [EXPIRATIONDTM] [PERSONID] 8 14 0.444311208289775 10.22

0.610519650457415 2010-06-16 15:19:59.923 [Docushare].[dbo].[Link_table] NULL [source_id] [source_isDeleted] 1 1 1.04077676518482 58.66

0.534776608408152 2010-06-10 12:09:52.577 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [UNIQUEINDEXSW] NULL [NAME] 2 2 0.855095312453073 31.27

0.521905283660054 2010-06-10 12:09:52.600 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [UNIQUEINDEXSW] NULL [NAME], [TABLENM] 2 2 1.05863140701837 24.65

0.50942170411337 2010-06-29 11:01:21.350 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW], [SHIFTTYPEID] [SHIFTSTARTDATE] NULL 30 30 0.0393072302556612 43.2

0.507614823861632 2010-06-10 12:09:55.783 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [TABLENM], [SEGMENTNM] 2 2 1.2368782257837 20.52

0.49675428260216 2010-06-10 12:09:51.363 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD] NULL [PARENTOBJECTNM], [COLUMNNM], [COLUMNORDERNUM], [DATATYPENM] 2 2 1.26917292437956 19.57

0.4803092938503 2010-06-17 15:39:38.467 [wfcdb].[dbo].[SHIFTASSIGNMNT] [EMPLOYEEID], [DELETEDSW], [LOCKEDSW] [SHIFTSTARTDATE] [SHIFTASSIGNID], [GROUPSHIFTID] 1 19 0.219249232597024 11.53

0.474500025870103 2010-06-28 19:55:17.873 [msdb].[dbo].[backupset] [database_name] NULL [backup_set_id], [backup_set_uuid], [media_set_id], [first_family_number], [first_media_number], [last_family_number], [last_media_number], [catalog_family_number], [catalog_media_number], [position], [expiration_date], [software_vendor_id], [name], [descr 2 2 0.269357417047061 88.08

0.471415134033901 2010-06-23 15:02:20.500 [wfcdb].[dbo].[WDMDEVICEUPDATE] [WDMDEVICEID], [DELETEFROMDEVICESW] NULL [EMPLOYEEID], [BADGENUM], [TERMINALRULEID], [FULLNM], [SCHEDULEVERSION], [UPDATEEMPLOYEESW], [UPDATESCHEDULESW], [LASTSHIFTENDDTM], [GENERICSCHEDID], [UPDATEDTM], [MANAGERSW], [BIOMETRICSW] 2 27 0.0460195566131612 37.94

0.469827371065707 2010-06-10 12:08:43.720 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD] NULL [PARENTOBJECTNM], [COLUMNNM] 1 1 1.10991583053557 42.33

0.448783630056277 2010-06-23 09:22:45.803 [wfcdb].[dbo].[ACCSCONTRPOINT] [INACTIVESW] NULL [ACCSCONTRPOINTID] 7 11 0.225281677654875 18.11

0.409306980936878 2010-06-10 12:09:51.557 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD], [NULLABLESW] NULL [PARENTOBJECTNM], [COLUMNNM], [COLUMNORDERNUM] 2 2 1.28389893643939 15.94

0.40058289437256 2010-06-10 12:09:51.510 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD], [NULLABLESW] NULL [PARENTOBJECTNM], [COLUMNNM] 2 2 1.25025872151236 16.02

0.39432783909861 2010-06-30 05:16:45.433 [BCF_DW].[ODS].[WhseInventory_A0AWREP] [ActiveInactiveFlag] NULL [WarehouseCode], [ItemSurrogate] 1 1 0.928923060302969 42.45

0.391978453704069 2010-06-30 05:39:05.580 [BCF_DW].[DW].[DimItem] [Productcode] [ProductCategory], [Active/InactiveFlag] [Surrogate] 2 1 1.11770303308831 35.07

0.386073736994316 2010-06-30 05:21:53.380 [BCF_DW].[DW].[DimItem] [Productcode] NULL [SixCode], [ShippingSize], [Packcode], [Labelcode] 1 1 0.42925699020938 89.94

0.380855977865585 2010-06-30 05:21:53.557 [BCF_DW].[DW].[DimItem] [Productcode] NULL [PrimaryAlias], [SixCode], [ShippingSize], [ShippingFactor] 1 1 0.621298495702423 61.3

0.376529120261645 2010-06-30 05:38:38.190 [BCF_DW].[DW].[DimItem] [Productcode] [ProductCategory], [Active/InactiveFlag], [LabelStatus] [Orderlinedescription], [PrimaryAlias], [SixCode], [ShippingSize], [Packcode], [Labelcode], [BusinessUnit], [LabelDescription] 1 1 1.00892047229808 37.32

0.375687046897789 2010-06-30 05:14:26.590 [BCF_DW].[DW].[DimItem] [BaseCaseConvFactor] NULL [PrimaryAlias], [ShippingSize], [ShippingFactor], [Olivecode], [Containercode], [Sizecode], [Packcode] 2 1 0.950625118668495 39.52

0.36793876715364 2010-06-29 08:14:09.913 [WSS_Content].[dbo].[AllUserData] [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DirName], [tp_DeleteTransactionId], [float3], [tp_IsCurrentVersion], [tp_CalculatedVersion] NULL NULL 5 34 0.0418473644458442 25.86

0.36163008930772 2010-06-30 05:14:07.880 [BCF_DW].[DW].[DimItem] [LabelStatus], [StrategicSegment] NULL [PrimaryAlias] 1 1 2.83854073239968 12.74

0.357928230407335 2010-06-29 11:33:02.500 [WSS_Content].[dbo].[AllDocs] [SiteId], [WebId], [DeleteTransactionId], [Level] NULL NULL 1 1 0.82586116845255 43.34

0.350714930724604 2010-06-24 10:52:25.507 [wfcdb].[dbo].[TOTALEVENTTS] NULL [LAST_TOTALTIME] [PERSONID], [TOTALIZATIONSTATUS], [NEXTTOTALDTM] 5 17 0.0285263966297342 72.32

0.313525036171111 2010-06-23 09:18:05.360 [wfcdb].[dbo].[ACCSCONTRPOINT] [INACTIVESW] NULL [ACCSCONTRPOINTID], [ACCSCONTRPOINTNM], [ACCSCONTRPOINTDSC], [VISIBLESW] 4 11 0.168155020740741 16.95

0.286734166257502 2010-06-27 01:27:00.550 [wfcdb].[dbo].[PERSON] NULL [MGRSIGNOFFTHRUDTM] [PERSONID] 4 4 0.189689181170616 37.79

0.279153637075558 2010-06-29 12:55:27.020 [wfcdb_test].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [PRODUCTSHORTNM], [TABLENM] 2 3 0.568425243485152 16.37

0.276936778625966 2010-06-29 12:55:27.020 [wfcdb_test].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [PRODUCTSHORTNM], [TABLENM], [PARENTTABLENM] 2 3 0.568425243485152 16.24

0.265996874414212 2010-06-10 12:10:00.650 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE], [CASCADEDELETESW] NULL [NAME] 1 1 0.64250452757056 41.4

0.263502530810827 2010-06-10 12:09:52.287 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [SEGMENTNM] 1 1 1.16439474507657 22.63

0.262489905774701 2010-06-10 12:08:53.250 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [TABLENM] 1 1 0.859214094188875 30.55

0.256357708779694 2010-06-30 08:36:26.763 [cats].[dbo].[contact] [date_entered] NULL NULL 2 3 0.359648861924374 23.76

0.253937884812294 2010-06-10 12:09:58.540 [wfcdb].[dbo].[KCSDBOBJECT] [TYPE] NULL [NAME], [TABLENM], [PARENTTABLENM] 1 1 1.59508721615762 15.92

0.253403973545681 2010-06-29 12:55:27.020 [wfcdb_test].[dbo].[KCSDBOBJECT] [TYPE], [TABLENM] NULL [NAME], [PRODUCTSHORTNM] 2 3 0.568425243485152 14.86

0.253034892085609 2010-06-28 15:59:36.940 [msdb].[dbo].[backupset] [database_name] NULL [media_set_id] 1 1 0.278274378187187 90.93

0.253033624417778 2010-06-28 15:59:36.937 [msdb].[dbo].[backupset] [database_name] NULL [backup_set_id] 1 1 0.266913105925926 94.8

0.251887101964777 2010-06-28 09:25:39.213 [wfcdb].[dbo].[PERSON] [DELETEDSW] [PERSONID], [MGRSIGNOFFTHRUDTM] [PERSONNUM], [FULLNM] 2 4 0.160274307689474 39.29

0.251298457496401 2010-06-28 20:31:22.237 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_DirName] NULL 14 32 0.0423118361894534 18.56

0.24778915806788 2010-06-22 09:18:52.950 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [DELETEDSW] [EVENTDTM], [EVENTTYPEID] [WFAREPACTYSPANID], [DIRECTSW] 2 2 0.382863346829233 32.36

0.242317528165047 2010-06-29 11:40:25.307 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DirName], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] NULL NULL 4 5 0.288130235630258 16.82

0.229687323021434 2010-06-23 15:02:11.440 [wfcdb].[dbo].[WDMDEVICEUPDATE] [WDMDEVICEID], [UPDATEEMPLOYEESW], [DELETEFROMDEVICESW] NULL [EMPLOYEEID], [BADGENUM], [TERMINALRULEID], [FULLNM], [SCHEDULEVERSION], [UPDATESCHEDULESW], [LASTSHIFTENDDTM], [GENERICSCHEDID], [UPDATEDTM], [MANAGERSW], [BIOMETRICSW] 1 13 0.0389769592257521 45.33

0.229189583914718 2010-06-29 21:04:50.550 [wfcdb].[dbo].[DWE_TASKS] [STATE] NULL [ID], [WORKFLOW_ID], [PARENT], [EARLIEST_START_DATE] 7 7 0.165360450154919 19.8

0.202642244738994 2010-06-23 13:11:43.890 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [EVENTDTM], [DELETEDSW] [EVENTTYPEID] [WFAREPACTYSPANID], [ALLOCATEDSECSQTY] 4 4 0.152270998451303 33.27

0.1982970187898 2010-06-28 20:11:42.990 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DirName], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_ID] NULL 1 1 1.53361963487858 12.93

0.197785040682308 2010-06-29 21:04:50.370 [wfcdb].[dbo].[DWE_TASKS] [STATE] NULL [ID], [CLASS_TYPE], [WORKFLOW_ID] 7 7 0.0402206488423606 70.25

0.19123587561384 2010-06-10 12:09:51.620 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD], [DEFAULTVALUESW] NULL [PARENTOBJECTNM], [COLUMNNM] 1 1 0.897821012271549 21.3

0.191133332919839 2010-06-29 16:08:03.610 [wfcdb].[dbo].[BASEWAGERTHIST] NULL [EFFECTIVEDTM], [EXPIRATIONDTM] [EMPLOYEEID], [BASEWAGEHOURLYAMT] 6 6 0.280418622241548 11.36

0.189895879215535 2010-06-10 12:09:51.650 [wfcdb].[dbo].[KCSDBCOLUMN] [PARENTOBJTYPECD], [DEFAULTVALUESW] NULL [PARENTOBJECTNM], [COLUMNNM], [COLUMNORDERNUM] 1 1 0.855772326343105 22.19

0.188567273938676 2010-06-30 05:00:47.280 [BCF_DW].[ODS].[ItemUPCMapping_A8AYREP] [AliasFormat] NULL [ItemAlias] 1 1 0.641821899042463 29.38

0.186075852475594 2010-06-24 10:52:12.623 [wfcdb].[dbo].[TOTALEVENTTS] NULL [LAST_TOTALTIME] [PERSONID], [TOTALIZATIONSTATUS], [EMPLOYEEINPROC_SW], [NEXTTOTALDTM] 4 9 0.0292558295167829 70.67

0.18261552478506 2010-06-23 14:39:09.853 [wfcdb].[dbo].[PERSONSTATUSMM] [USERACCTSTATID] [PERSONID], [EXPIRATIONDTM] NULL 4 4 0.212739427755195 21.46

0.175485973798761 2010-06-29 16:08:03.610 [wfcdb].[dbo].[WTKEMPLOYEE] NULL [PAYRULEID] [WTKEMPLOYEEID], [TIMEZONEID], [EMPLOYEEID], [SUPERVISORID], [WORKERTYPEID] 6 6 0.280418622241548 10.43

0.171917160047948 2010-06-24 12:37:54.587 [wfcdb].[dbo].[WFAUNITSTR] NULL [PARENTID], [EMPLOYEEID], [EFFSTARTDTM], [EFFENDDTM] NULL 1 1 0.367030657660008 46.84

0.168975122586784 2010-06-27 01:27:00.550 [wfcdb].[dbo].[EMPPATTRNASGN] [DELETEDSW] [EFFECTIVEDTM], [EXPIRATIONDTM], [POPULATEDTHRUDTM] [EMPPATTRNASGNID], [EMPLOYEEID] 4 4 0.189689181170616 22.27

0.161321024503993 2010-06-29 11:33:10.537 [WSS_Content].[dbo].[ContentTypeUsage] [SiteId], [WebId] NULL [ContentTypeId], [ListId], [Class] 1 1 0.189210678517467 85.26

0.153502356372968 2010-06-28 11:13:00.617 [msdb].[dbo].[backupset] NULL [backup_start_date] [media_set_id], [expiration_date], [name], [description], [backup_finish_date], [type], [backup_size], [database_name] 1 1 0.487773614149882 31.47

0.148351403798358 2010-06-30 08:36:26.763 [cats].[dbo].[isl] [contactno] NULL [icode], [i4], [i3], [i2], [i1], [scode], [s4], [s3], [s2], [s1], [lcode], [l4], [l3], [l2], [l1], [mfgcode], [mfgdate], [mfgtime], [linenum], [islage], [qty], [seq], [islspare] 1 2 0.339787915250476 21.83

0.136615396113293 2010-06-23 08:55:19.263 [wfcdb].[dbo].[PUNCHEVENT] [EMPLOYEEID], [DELETEDSW] NULL [PUNCHEVENTID], [DATASOURCEID], [LABORACCTID], [WORKRULEID], [BREAKRULEID], [DEDUCTRULEID], [OVERRIDETYPEID], [PUNCHDTM], [TIMEZONEID], [CNCLWRKRLTRANSFSW], [ENTEREDONDTM], [CANCELDEDUCTSW], [ORGIDSID], [EXCEPTIONRESOLVESW] 3 4 0.0803430934564178 42.51

0.13146233754044 2010-06-30 05:38:38.190 [BCF_DW].[DW].[DimWhseInventory] NULL [WarehouseCode], [ActiveInactiveFlag] [PrimaryAlias] 1 1 1.00892047229808 13.03

0.125987757875314 2010-06-28 09:25:39.217 [wfcdb].[dbo].[PRSNACCSASSIGN] [ACCESSPROFID] NULL [PERSONID] 2 4 0.0904824460466201 34.81

0.125269953130667 2010-06-30 04:32:26.380 [WSS_Content].[dbo].[AllLists] [tp_DeleteTransactionId] NULL NULL 2 2 0.0690116533333333 90.76

0.121270779090081 2010-06-30 05:39:05.580 [BCF_DW].[DW].[DimWhseInventory] [ActiveInactiveFlag] [WarehouseCode] [ItemSurrogate], [PrimaryAlias] 2 1 1.11770303308831 10.85

0.117443379853263 2010-06-24 12:52:58.613 [wfcdb].[dbo].[WFAACTIVITY] [ACTYLEVELCNT] [SEARCHNM], [COMPLSTATTYPEID] NULL 1 1 0.122426123061882 95.93

0.106326639447189 2010-06-24 12:52:58.633 [wfcdb].[dbo].[WFAACTIVITY] [ACTYLEVELCNT] [SEARCHNM], [COMPLSTATTYPEID] [WFAACTIVITYID], [ACTIVITYNM], [ACTIVITYDSC], [ACTSTARTDTM], [ACTCOMPLDTM], [HELDSTATTYPEID] 1 1 0.142548115628354 74.59

0.105683496982452 2010-06-28 09:25:39.217 [wfcdb].[dbo].[PRSNACCSASSIGN] NULL [ACCESSPROFID] [PERSONID] 2 4 0.0904824460466201 29.2

0.10561385321496 2010-06-24 11:11:55.227 [wfcdb].[dbo].[WFAACTIVITY] [ACTYLEVELCNT] NULL [WFAACTIVITYID], [ACTIVITYNM], [ACTIVITYDSC], [ACTSTARTDTM], [ACTCOMPLDTM], [COMPLSTATTYPEID], [HELDSTATTYPEID] 1 1 0.141820670357137 74.47

0.102194150483818 2010-06-23 13:11:44.400 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [EVENTDTM], [DELETEDSW] [EVENTTYPEID] [WFAREPACTYSPANID], [WFAUNITID] 2 2 0.0807475904581369 63.28

0.0945354700868116 2010-06-28 20:20:13.530 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [float3], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_DirName] NULL 7 17 0.0492988475630014 11.28

0.0824932566211118 2010-06-28 20:31:24.880 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_DirName], [datetime2] NULL 2 15 0.025807369504493 21.31

0.0824718282402935 2010-06-18 13:46:18.090 [wfcdb].[dbo].[WTKEMPLOYEE] [PAYRULEID] NULL NULL 4 5 0.115264609699921 14.31

0.0791399608957924 2010-06-27 01:27:01.307 [wfcdb].[dbo].[WDMDEVACTIONS] [WDMDEVPACKAGEID] NULL NULL 2 2 0.13404464921374 29.52

0.0786020787159773 2010-06-27 01:27:01.210 [wfcdb].[dbo].[WDMDEVACTIONS] NULL [WDMDEVACTNSTATID], [UPDATEDTM] [WDMDEVACTIONSID] 3 3 0.0749662171826202 34.95

0.0767706463051111 2010-06-27 01:27:00.960 [wfcdb].[dbo].[WDMDEVACTIONS] NULL [WDMDEVACTNSTATID], [UPDATEDTM] [WDMDEVACTIONSID], [WDMDEVICEID] 3 3 0.0294580585185185 86.87

0.0667293977916043 2010-06-07 14:58:55.310 [wfcdb].[dbo].[WTKEMPLOYEE] NULL [PAYRULEID] [PERSONID] 2 2 0.29896683598389 11.16

0.0594981651940207 2010-06-24 12:09:31.083 [cats].[dbo].[isl] NULL [s1] [icode], [i4], [i3], [i2], [i1], [scode], [s4], [s3], [s2], [lcode], [l4], [l3], [l2], [l1], [mfgcode], [mfgdate], [mfgtime], [linenum], [islage], [qty], [contactno], [seq], [islspare] 1 1 0.722942468943144 8.23

0.0514866938688765 2010-06-04 15:49:56.573 [cats].[dbo].[customer] NULL [fname] [consno], [contfilenum], [lname], [st_number], [st_name], [city], [state], [zip], [h_phone], [w_phone], [mobile] 1 1 0.22002860627725 23.4

0.0503841959774502 2010-06-29 15:19:29.100 [wfcdb].[dbo].[COMBHOMEACCT] NULL [EFFECTIVEDTM], [EXPIRATIONDTM] [EMPLOYEEID], [WFCJOBORGID] 1 1 0.53543247584963 9.41

0.0502174783048419 2010-06-22 09:01:48.493 [wfcdb].[dbo].[WFAREPACTYSPAN] [EMPLOYEEID], [EVENTDTM], [DELETEDSW] [EVENTTYPEID] [WFAREPACTYSPANID], [DIRECTSW] 1 1 0.114677959134145 43.79

0.0466297892468328 2010-06-24 12:09:31.083 [cats].[dbo].[contact] NULL [date_recd] [contactno], [custfilenum], [imageid], [method], [summary], [date_entered], [time_entered], [date_chgd], [time_chgd], [useradd], [userchg], [bitfield], [ck1amt], [ck2amt], [ck1nbr], [ck2nbr], [misctable], [txt1], [txt2], [status1], [status2], [count1], [co 1 1 0.722942468943144 6.45

0.0266180982069075 2010-06-29 11:33:07.217 [WSS_Content].[dbo].[AllDocs] [SiteId], [DeleteTransactionId] [DirName] NULL 1 1 0.0655779704530858 40.59

0.0264166511391852 2010-06-04 13:08:34.100 [wfcdb].[dbo].[PRSNACCSASSIGN] [PREFERENCEPROFID] NULL NULL 1 1 0.0302839059259259 87.23

0.0263943190479446 2010-06-14 10:42:16.027 [wfcdb].[dbo].[PRSNACCSASSIGN] [ISOTAPPROVERSW] [PERSONID] NULL 1 1 0.0581244638800806 45.41

0.0236076936409675 2010-06-28 20:20:13.597 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [bit2], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_DirName] NULL 4 5 0.0586526550086149 8.05

0.0229101606671567 2010-06-29 11:32:59.023 [WSS_Content].[dbo].[AllDocs] [SiteId], [WebId], [DeleteTransactionId] [DirName] NULL 2 1 0.0267829795033396 85.54

0.0108414358798281 2010-06-28 20:14:04.613 [WSS_Content].[dbo].[AllUserData] [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DirName], [tp_DeleteTransactionId], [int3], [float3], [tp_IsCurrentVersion], [tp_CalculatedVersion] NULL NULL 1 1 0.0468110357505533 23.16

0.00729903032495324 2010-06-28 20:10:47.740 [WSS_Content].[dbo].[AllUserData] [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [bit2], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_DirName] NULL 1 1 0.0813715755290217 8.97

0.005509230244658 2010-06-28 20:20:12.003 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_IsCurrent], [tp_DeleteTransactionId], [float3], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_DirName], [datetime1] NULL 1 1 0.0258164491314808 21.34

0.00487837310488889 2010-06-24 11:11:55.197 [wfcdb].[dbo].[WFAACTIVITY] [ACTYLEVELCNT] NULL NULL 1 1 0.00912186444444444 53.48

0.00472151371028667 2010-06-28 20:20:01.990 [WSS_Content].[dbo].[AllUserData] [tp_ListId], [tp_SiteId], [tp_RowOrdinal], [tp_Editor], [tp_IsCurrent], [tp_DeleteTransactionId], [tp_IsCurrentVersion], [tp_CalculatedVersion] [tp_Modified], [tp_DirName] NULL 1 1 0.0586523442271636 8.05

0.00417066067185185 2010-06-10 12:08:42.943 [wfcdb].[dbo].[TOTALEVENTTS] [EMPLOYEEINPROC_SW] NULL NULL 1 1 0.0080375037037037 51.89

(284 row(s) affected)

 

Answer 10

Ray,

 

Thanks for sharing the info. From the data, you are using 32 bit Standard edition with SP3, and your db size is little over 6 gigs and your PLE is around 10 minutes. Not extremely bad but still low.

 

I see that PAGEIOLATCH_SH is your second biggest wait and that means sql  Server is waiting to read the table/index data from disk to memory and this is one of the indicator for the low PLE. You should look for missing indexes and see for procedures that’s doing lot of IO. In the link I gave you earlier look for queries to help find them and add the missing indexes.

 

Usually keeping the data files and log files on the same disk will not get you good performance. You may want to separate them to different disks because the write pattern for data files and log files are different.

 

What is the total memory available on this box and how much did you set for SQL Server? Look for Target and Total server memory Perfmon counters. If it is only 4 GB then you may want to enable /3GB switch but if you have more than 4 GB then you may want to enable AWE.

 

Ref: http://www.jimmcleod.net/blog/index.php/2008/06/03/sql-server-2005-and-awe-memory/

 

If you can verify that you are being affected by SQL Server trimming workset problem then you could install CU4 and try to use Lock pages in memory also and see if that helps.

 

http://blogs.msdn.com/b/suhde/archive/2009/05/20/lock-pages-in-memory-now-available-for-standard-edition-of-sql-server.aspx

 

EDIT:

Some good references yo umay want to catch up on when you have time.

http://technet.microsoft.com/en-us/library/cc966401.aspx

http://technet.microsoft.com/en-us/library/cc966540.aspx

http://sqlcat.com/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx


http://SankarReddy.com/
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter