September 22, 2010 at 3:00 pm
Here is the part of the query that it taking too long (temp tables involved run in few seconds which is fine)
select a.empno,elno,sdate,enddate,place,jcode,stprev,statecode,jrev,
spr1,spr2,spr3,spr4,spr5,revec,ctsrev,revid,rload
ecode1,ecode2,ecode3,ecode4,ecode5
into #dev2
from employee a inner join #empdts b
on a.empno=b.empno
inner join #dev c
on a.empno = c.empno
where a.sdate between b.efdt and b.exdt
The same query is ran on idential databases but the duration varies about 12hrs. bigger(900gb) database is super fast than the smaller one (300gb)
Execution plan for smaller-poor performing database.
|--Table Insert(OBJECT:([#dev2]), SET:([#dev2].[empno] = [Union1009],[#dev2].[elno] = [Union1011],[#dev2].[sdate] = [Union1014],[#dev2].[enddate] = [Union1015],[#dev2].[place] = [Union1023],[#dev2].[jcode] = [Union1026],[#dev2].[stprev] = [Union1021],[#dev2].[statecode] = [Union1024],[#dev2].[jrev] = [Union1025],[#dev2].[spr1] = [Union1016],[#dev2].[spr2] = [Union1017],[#dev2].[spr3] = [Union1018],[#dev2].[spr4] = [Union1019],[#dev2].[spr5] = [Union1020],[#dev2].[revec] = [Union1036],[#dev2].[ctsrev] = [Union1037],[#dev2].[revid] = [Union1034],[#dev2].[rload] = [Union1074]))
|--Top(ROWCOUNT est 0)
|--Nested Loops(Inner Join, OUTER REFERENCES:(.[efdt], .[exdt], [c].[empno]))
|--Hash Match(Inner Join, HASH:([c].[empno])=(.[empno]), RESIDUAL:([tempdb].[dbo].[#empdts].[empno] as .[empno]=[tempdb].[dbo].[#dev].[empno] as [c].[empno]))
| |--Table Scan(OBJECT:([tempdb].[dbo].[#dev] AS [c]))
| |--Table Scan(OBJECT:([tempdb].[dbo].[#empdts] AS ))
|--Concatenation
|--Nested Loops(Inner Join, OUTER REFERENCES:([PtnIds1097], [Uniq1005], [MI].[empno], [MI].[sdate], [MI].[Reven_ID], [MI].[ASO_optin]) PARTITION ID:([PtnIds1097]) OPTIMIZED)
| |--Compute Scalar(DEFINE:([PtnIds1097]=RangePartitionNew([State_CTREV].[dbo].[employee_I].[sdate] as [MI].[sdate],(1),'2004-01-01 00:00:00.000','2004-02-01 00:00:00.000','2004-03-01 00:00:00.000','2004-04-01 00:00:00.000','2004-05-01 00:00:00.000','2004-06-01 00:00:00.000','2004-07-01 00:00:00.000','2004-08-01 00:00:00.000','2004-09-01 00:00:00.000','2004-10-01 00:00:00.000','2004-11-01 00:00:00.000','2004-12-01 00:00:00.000','2005-01-01 00:00:00.000','2005-02-01 00:00:00.000','2005-03-01 00:00:00.000','2005-04-01 00:00:00.000','2005-05-01 00:00:00.000','2005-06-01 00:00:00.000','2005-07-01 00:00:00.000','2005-08-01 00:00:00.000','2005-09-01 00:00:00.000','2005-10-01 00:00:00.000','2005-11-01 00:00:00.000','2005-12-01 00:00:00.000','2006-01-01 00:00:00.000','2006-02-01 00:00:00.000','2006-03-01 00:00:00.000','2006-04-01 00:00:00.000','2006-05-01 00:00:00.000','2006-06-01 00:00:00.000','2006-07-01 00:00:00.000','2006-08-01 00:00:00.000','2006-09-01 00:00:00.000','2006-10-01 00:00:00.000','2006-11-01 00:00:00.000','2006-12-01 00:00:00.000','2007-01-01 00:00:00.000','2007-02-01 00:00:00.000','2007-03-01 00:00:00.000','2007-04-01 00:00:00.000','2007-05-01 00:00:00.000','2007-06-01 00:00:00.000','2007-07-01 00:00:00.000','2007-08-01 00:00:00.000','2007-09-01 00:00:00.000','2007-10-01 00:00:00.000','2007-11-01 00:00:00.000','2007-12-01 00:00:00.000','2008-01-01 00:00:00.000','2008-02-01 00:00:00.000','2008-03-01 00:00:00.000','2008-04-01 00:00:00.000','2008-05-01 00:00:00.000','2008-06-01 00:00:00.000','2008-07-01 00:00:00.000','2008-08-01 00:00:00.000','2008-09-01 00:00:00.000','2008-10-01 00:00:00.000','2008-11-01 00:00:00.000','2008-12-01 00:00:00.000','2009-01-01 00:00:00.000','2009-02-01 00:00:00.000','2009-03-01 00:00:00.000','2009-04-01 00:00:00.000','2009-05-01 00:00:00.000','2009-06-01 00:00:00.000','2009-07-01 00:00:00.000','2009-08-01 00:00:00.000','2009-09-01 00:00:00.000','2009-10-01 00:00:00.000','2009-11-01 00:00:00.000','2009-12-01 00:00:00.000','2010-01-01 00:00:00.000','2010-02-01 00:00:00.000','2010-03-01 00:00:00.000','2010-04-01 00:00:00.000','2010-05-01 00:00:00.000','2010-06-01 00:00:00.000','2010-07-01 00:00:00.000','2010-08-01 00:00:00.000','2010-09-01 00:00:00.000','2010-10-01 00:00:00.000','2010-11-01 00:00:00.000','2010-12-01 00:00:00.000','2011-01-01 00:00:00.000','2011-02-01 00:00:00.000','2011-03-01 00:00:00.000','2011-04-01 00:00:00.000','2011-05-01 00:00:00.000','2011-06-01 00:00:00.000','2011-07-01 00:00:00.000','2011-08-01 00:00:00.000','2011-09-01 00:00:00.000','2011-10-01 00:00:00.000','2011-11-01 00:00:00.000','2011-12-01 00:00:00.000','2012-01-01 00:00:00.000','2012-02-01 00:00:00.000','2012-03-01 00:00:00.000','2012-04-01 00:00:00.000','2012-05-01 00:00:00.000','2012-06-01 00:00:00.000','2012-07-01 00:00:00.000','2012-08-01 00:00:00.000','2012-09-01 00:00:00.000','2012-10-01 00:00:00.000','2012-11-01 00:00:00.000','2012-12-01 00:00:00.000','2013-01-01 00:00:00.000','2013-02-01 00:00:00.000','2013-03-01 00:00:00.000','2013-04-01 00:00:00.000','2013-05-01 00:00:00.000','2013-06-01 00:00:00.000','2013-07-01 00:00:00.000','2013-08-01 00:00:00.000','2013-09-01 00:00:00.000','2013-10-01 00:00:00.000','2013-11-01 00:00:00.000','2013-12-01 00:00:00.000')))
| | |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1157], [Expr1158], [Expr1159]))
| | |--Merge Interval
| | | |--Concatenation
| | | |--Compute Scalar(DEFINE:(([Expr1152],[Expr1153],[Expr1151])=GetRangeWithMismatchedTypes([tempdb].[dbo].[#empdts].[efdt] as .[efdt],NULL,(22))))
| | | | |--Constant Scan
| | | |--Compute Scalar(DEFINE:(([Expr1155],[Expr1156],[Expr1154])=GetRangeWithMismatchedTypes(NULL,[tempdb].[dbo].[#empdts].[exdt] as .[exdt],(42))))
| | | |--Constant Scan
| | |--IX Seek(OBJECT:([State_CTREV].[dbo].[employee_I].[IX_allfields] AS [MI]), SEEK:([MI].[empno]=[tempdb].[dbo].[#dev].[empno] as [c].[empno] AND [MI].[sdate] > [Expr1157] AND [MI].[sdate] < [Expr1158]), WHERE:([State_CTREV].[dbo].[employee_I].[Reven_ID] as [MI].[Reven_ID]='NA' OR [State_CTREV].[dbo].[employee_I].[Reven_ID] as [MI].[Reven_ID]='SEN') ORDERED FORWARD)
| |--Clustered IX Seek(OBJECT:([State_CTREV].[dbo].[employee_I].[IX_main] AS [MI]), SEEK:([MI].[Reven_ID]=[State_CTREV].[dbo].[employee_I].[Reven_ID] as [MI].[Reven_ID] AND [MI].[ASO_optin]=[State_CTREV].[dbo].[employee_I].[ASO_optin] as [MI].[ASO_optin] AND [MI].[sdate]=[State_CTREV].[dbo].[employee_I].[sdate] as [MI].[sdate] AND [MI].[empno]=[State_CTREV].[dbo].[employee_I].[empno] as [MI].[empno] AND [Uniq1005]=[Uniq1005]) LOOKUP ORDERED FORWARD PARTITION ID:([PtnIds1097]))
|--Nested Loops(Inner Join, OUTER REFERENCES:([PtnIds1098], [Uniq1008], [MA].[empno], [MA].[sdate], [MA].[Reven_ID], [MA].[ASO_optin]) PARTITION ID:([PtnIds1098]) OPTIMIZED)
|--Compute Scalar(DEFINE:([PtnIds1098]=RangePartitionNew([State_CTREV].[dbo].[employee_A].[sdate] as [MA].[sdate],(1),'2004-01-01 00:00:00.000','2004-02-01 00:00:00.000','2004-03-01 00:00:00.000','2004-04-01 00:00:00.000','2004-05-01 00:00:00.000','2004-06-01 00:00:00.000','2004-07-01 00:00:00.000','2004-08-01 00:00:00.000','2004-09-01 00:00:00.000','2004-10-01 00:00:00.000','2004-11-01 00:00:00.000','2004-12-01 00:00:00.000','2005-01-01 00:00:00.000','2005-02-01 00:00:00.000','2005-03-01 00:00:00.000','2005-04-01 00:00:00.000','2005-05-01 00:00:00.000','2005-06-01 00:00:00.000','2005-07-01 00:00:00.000','2005-08-01 00:00:00.000','2005-09-01 00:00:00.000','2005-10-01 00:00:00.000','2005-11-01 00:00:00.000','2005-12-01 00:00:00.000','2006-01-01 00:00:00.000','2006-02-01 00:00:00.000','2006-03-01 00:00:00.000','2006-04-01 00:00:00.000','2006-05-01 00:00:00.000','2006-06-01 00:00:00.000','2006-07-01 00:00:00.000','2006-08-01 00:00:00.000','2006-09-01 00:00:00.000','2006-10-01 00:00:00.000','2006-11-01 00:00:00.000','2006-12-01 00:00:00.000','2007-01-01 00:00:00.000','2007-02-01 00:00:00.000','2007-03-01 00:00:00.000','2007-04-01 00:00:00.000','2007-05-01 00:00:00.000','2007-06-01 00:00:00.000','2007-07-01 00:00:00.000','2007-08-01 00:00:00.000','2007-09-01 00:00:00.000','2007-10-01 00:00:00.000','2007-11-01 00:00:00.000','2007-12-01 00:00:00.000','2008-01-01 00:00:00.000','2008-02-01 00:00:00.000','2008-03-01 00:00:00.000','2008-04-01 00:00:00.000','2008-05-01 00:00:00.000','2008-06-01 00:00:00.000','2008-07-01 00:00:00.000','2008-08-01 00:00:00.000','2008-09-01 00:00:00.000','2008-10-01 00:00:00.000','2008-11-01 00:00:00.000','2008-12-01 00:00:00.000','2009-01-01 00:00:00.000','2009-02-01 00:00:00.000','2009-03-01 00:00:00.000','2009-04-01 00:00:00.000','2009-05-01 00:00:00.000','2009-06-01 00:00:00.000','2009-07-01 00:00:00.000','2009-08-01 00:00:00.000','2009-09-01 00:00:00.000','2009-10-01 00:00:00.000','2009-11-01 00:00:00.000','2009-12-01 00:00:00.000','2010-01-01 00:00:00.000','2010-02-01 00:00:00.000','2010-03-01 00:00:00.000','2010-04-01 00:00:00.000','2010-05-01 00:00:00.000','2010-06-01 00:00:00.000','2010-07-01 00:00:00.000','2010-08-01 00:00:00.000','2010-09-01 00:00:00.000','2010-10-01 00:00:00.000','2010-11-01 00:00:00.000','2010-12-01 00:00:00.000','2011-01-01 00:00:00.000','2011-02-01 00:00:00.000','2011-03-01 00:00:00.000','2011-04-01 00:00:00.000','2011-05-01 00:00:00.000','2011-06-01 00:00:00.000','2011-07-01 00:00:00.000','2011-08-01 00:00:00.000','2011-09-01 00:00:00.000','2011-10-01 00:00:00.000','2011-11-01 00:00:00.000','2011-12-01 00:00:00.000','2012-01-01 00:00:00.000','2012-02-01 00:00:00.000','2012-03-01 00:00:00.000','2012-04-01 00:00:00.000','2012-05-01 00:00:00.000','2012-06-01 00:00:00.000','2012-07-01 00:00:00.000','2012-08-01 00:00:00.000','2012-09-01 00:00:00.000','2012-10-01 00:00:00.000','2012-11-01 00:00:00.000','2012-12-01 00:00:00.000','2013-01-01 00:00:00.000','2013-02-01 00:00:00.000','2013-03-01 00:00:00.000','2013-04-01 00:00:00.000','2013-05-01 00:00:00.000','2013-06-01 00:00:00.000','2013-07-01 00:00:00.000','2013-08-01 00:00:00.000','2013-09-01 00:00:00.000','2013-10-01 00:00:00.000','2013-11-01 00:00:00.000','2013-12-01 00:00:00.000')))
| |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1166], [Expr1167], [Expr1168]))
| |--Merge Interval
| | |--Concatenation
| | |--Compute Scalar(DEFINE:(([Expr1161],[Expr1162],[Expr1160])=GetRangeWithMismatchedTypes([tempdb].[dbo].[#empdts].[efdt] as .[efdt],NULL,(22))))
| | | |--Constant Scan
| | |--Compute Scalar(DEFINE:(([Expr1164],[Expr1165],[Expr1163])=GetRangeWithMismatchedTypes(NULL,[tempdb].[dbo].[#empdts].[exdt] as .[exdt],(42))))
| | |--Constant Scan
| |--IX Seek(OBJECT:([State_CTREV].[dbo].[employee_A].[IX_allfields] AS [MA]), SEEK:([MA].[empno]=[tempdb].[dbo].[#dev].[empno] as [c].[empno] AND [MA].[sdate] > [Expr1166] AND [MA].[sdate] < [Expr1167]), WHERE:([State_CTREV].[dbo].[employee_A].[ASO_optin] as [MA].[ASO_optin]=(1) AND ([State_CTREV].[dbo].[employee_A].[Reven_ID] as [MA].[Reven_ID]='NA' OR [State_CTREV].[dbo].[employee_A].[Reven_ID] as [MA].[Reven_ID]='SEN')) ORDERED FORWARD)
|--Clustered IX Seek(OBJECT:([State_CTREV].[dbo].[employee_A].[IX_main] AS [MA]), SEEK:([MA].[Reven_ID]=[State_CTREV].[dbo].[employee_A].[Reven_ID] as [MA].[Reven_ID] AND [MA].[ASO_optin]=[State_CTREV].[dbo].[employee_A].[ASO_optin] as [MA].[ASO_optin] AND [MA].[sdate]=[State_CTREV].[dbo].[employee_A].[sdate] as [MA].[sdate] AND [MA].[empno]=[State_CTREV].[dbo].[employee_A].[empno] as [MA].[empno] AND [Uniq1008]=[Uniq1008]) LOOKUP ORDERED FORWARD PARTITION ID:([PtnIds1098]))
execution plan for Bigger and fast performing database.
|--Table Insert(OBJECT:([#dev2]), SET:([#dev2].[empno] = [Union1009],[#dev2].[elno] = [Union1011],[#dev2].[sdate] = [Union1014],[#dev2].[enddate] = [Union1015],[#dev2].[place] = [Union1023],[#dev2].[jcode] = [Union1026],[#dev2].[stprev] = [Union1021],[#dev2].[statecode] = [Union1024],[#dev2].[jrev] = [Union1025],[#dev2].[spr1] = [Union1016],[#dev2].[spr2] = [Union1017],[#dev2].[spr3] = [Union1018],[#dev2].[spr4] = [Union1019],[#dev2].[spr5] = [Union1020],[#dev2].[revec] = [Union1036],[#dev2].[ctsrev] = [Union1037],[#dev2].[revid] = [Union1034],[#dev2].[rload] = [Union1074]))
|--Top(ROWCOUNT est 0)
|--Parallelism(Gather Streams)
|--Hash Match(Inner Join, HASH:([c].[empno])=([Union1009]), RESIDUAL:([Union1009]=[tempdb].[dbo].[#dev].[empno] as [c].[empno] AND [Union1014]>=[tempdb].[dbo].[#empdts].[efdt] as .[efdt] AND [Union1014]<=[tempdb].[dbo].[#empdts].[exdt] as .[exdt]))
|--Hash Match(Inner Join, HASH:([c].[empno])=(.[empno]), RESIDUAL:([tempdb].[dbo].[#empdts].[empno] as .[empno]=[tempdb].[dbo].[#dev].[empno] as [c].[empno]))
| |--Bitmap(HASH:([c].[empno]), DEFINE:([Bitmap1190]))
| | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([c].[empno]))
| | |--Table Scan(OBJECT:([tempdb].[dbo].[#dev] AS [c]))
| |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:(.[empno]), WHERE:(PROBE([Bitmap1190])=TRUE))
| |--Table Scan(OBJECT:([tempdb].[dbo].[#empdts] AS ))
|--Concatenation
|--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([MI].[empno]))
| |--Nested Loops(Inner Join, OUTER REFERENCES:([PtnIds1095]) PARTITION ID:([PtnIds1095]))
| |--Parallelism(Distribute Streams, Demand Partitioning)
| | |--Constant Scan(VALUES:(((1)),((2)),((3)),((4)),((5)),((6)),((7)),((8)),((9)),((10)),((11)),((12)),((13)),((14)),((15)),((16)),((17)),((18)),((19)),((20)),((21)),((22)),((23)),((24)),((25)),((26)),((27)),((28)),((29)),((30)),((31)),((32)),((33)),((34)),((35)),((36)),((37)),((38)),((39)),((40)),((41)),((42)),((43)),((44)),((45)),((46)),((47)),((48)),((49)),((50)),((51)),((52)),((53)),((54)),((55)),((56)),((57)),((58)),((59)),((60)),((61)),((62)),((63)),((64)),((65)),((66)),((67)),((68)),((69)),((70)),((71)),((72)),((73)),((74)),((75)),((76)),((77)),((78)),((79)),((80)),((81)),((82)),((83)),((84)),((85)),((86)),((87)),((88)),((89)),((90)),((91)),((92)),((93)),((94)),((95)),((96)),((97)),((98)),((99)),((100)),((101)),((102)),((103)),((104)),((105)),((106)),((107)),((108)),((109)),((110)),((111)),((112)),((113)),((114)),((115)),((116)),((117)),((118)),((119)),((120)),((121)),((122)),((123)),((124)),((125)),((126)),((127)),((128)),((129)),((130)),((131)),((132)),((133)),((134)),((135)),((136)),((137)),((138)),((139)),((140)),((141)),((142)),((143)),((144)),((145)),((146)),((147)),((148)),((149)),((150)),((151)),((152)),((153)),((154)),((155)),((156)),((157))))
| |--Clustered IX Seek(OBJECT:([State_NYREV].[dbo].[employee_I].[IX_main] AS [MI]), SEEK:([MI].[Reven_ID]='NA' OR [MI].[Reven_ID]='SEN') ORDERED FORWARD PARTITION ID:([PtnIds1095]))
|--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([MA].[empno]))
|--Nested Loops(Inner Join, OUTER REFERENCES:([PtnIds1096]) PARTITION ID:([PtnIds1096]))
|--Parallelism(Distribute Streams, Demand Partitioning)
| |--Constant Scan(VALUES:(((1)),((2)),((3)),((4)),((5)),((6)),((7)),((8)),((9)),((10)),((11)),((12)),((13)),((14)),((15)),((16)),((17)),((18)),((19)),((20)),((21)),((22)),((23)),((24)),((25)),((26)),((27)),((28)),((29)),((30)),((31)),((32)),((33)),((34)),((35)),((36)),((37)),((38)),((39)),((40)),((41)),((42)),((43)),((44)),((45)),((46)),((47)),((48)),((49)),((50)),((51)),((52)),((53)),((54)),((55)),((56)),((57)),((58)),((59)),((60)),((61)),((62)),((63)),((64)),((65)),((66)),((67)),((68)),((69)),((70)),((71)),((72)),((73)),((74)),((75)),((76)),((77)),((78)),((79)),((80)),((81)),((82)),((83)),((84)),((85)),((86)),((87)),((88)),((89)),((90)),((91)),((92)),((93)),((94)),((95)),((96)),((97)),((98)),((99)),((100)),((101)),((102)),((103)),((104)),((105)),((106)),((107)),((108)),((109)),((110)),((111)),((112)),((113)),((114)),((115)),((116)),((117)),((118)),((119)),((120)),((121)),((122)),((123)),((124)),((125)),((126)),((127)),((128)),((129)),((130)),((131)),((132)),((133)),((134)),((135)),((136)),((137)),((138)),((139)),((140)),((141)),((142)),((143)),((144)),((145)),((146)),((147)),((148)),((149)),((150)),((151)),((152)),((153)),((154)),((155)),((156)),((157))))
|--Clustered IX Seek(OBJECT:([State_NYREV].[dbo].[employee_A].[IX_main] AS [MA]), SEEK:([MA].[Reven_ID]='NA' AND [MA].[ASO_optin]=(1) OR [MA].[Reven_ID]='SEN' AND [MA].[ASO_optin]=(1)) ORDERED FORWARD PARTITION ID:([PtnIds1096]))
September 22, 2010 at 3:05 pm
if you need sqlplan file of the execution plan , please check the atatchements.
September 22, 2010 at 3:28 pm
Tara-1044200 (9/22/2010)
if you need sqlplan file of the execution plan , please check the atatchements.
What attachments?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2010 at 5:30 pm
Gila, actually its the same text files which i copied in the post but could not attach them, can you give an idea with weired behaviour of my databases.
both db's are completely identical(tables,strcutures,indexes etc..) except the amount of data. i have 10 such databases but only this database is choosing a diferent execution plan than others and is running 18hrs instead of regualr 28min.
please let me know if you have any thoughts on this?
September 22, 2010 at 11:14 pm
Please can you post the execution plans as .sqlplan files? http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
There's a lot of important information which is not present in a copy-paste of part of the text plan.
Table and index defs would help a lot too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2010 at 11:29 pm
Tara-1044200 (9/22/2010)
both db's are completely identical(tables,strcutures,indexes etc..) except the amount of data.
Amount of data is a major factor in query plans.
Can you try a statistics update on the DB that's running slow?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 3:47 am
i am also interested in table/index definition
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 23, 2010 at 6:15 am
I have tried statistics update, drop/re create index, created new db and imported all the data,restored the same database again,wrapped the view in another view which the query is accessing,creates TVF (function)....
all of the above didnt change the query plan.
If it matters with the amount of data, i owuld expect smaller db to finish the query fastert than bigger one, but its reverse, any explanation?
September 23, 2010 at 9:42 am
can some one flush out any idea as to why 2 identical databases behaving different.
September 23, 2010 at 10:45 am
GilaMonster (9/22/2010)
Please can you post the execution plans as .sqlplan files? http://www.sqlservercentral.com/articles/SQLServerCentral/66909/There's a lot of important information which is not present in a copy-paste of part of the text plan.
Table and index defs would help a lot too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 24, 2010 at 8:28 am
Tara-1044200 (9/23/2010)
can some one flush out any idea as to why 2 identical databases behaving different.
Are they running on different servers?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply