I did a fullscan update statistics and both execution plans were identical.

Is there a way to figure out which statistic was out of date?

Thanks:

//Execution plan that runs as expected using '1/6/2010'

|--Compute Scalar(DEFINE:([Expr1012]=[AFTI_PROD].[dbo].[fnDEVICE_UNIT_CONVERT]([AFTI_PROD].[dbo].[T_EQUIPMENT_LOG_DATA].[READ_DATE],[Expr1014],[AFTI_PROD].[dbo].[T_EQUIPMENT_VARIABLE].[UNIT_ID],(72.),[Expr1015]), [Expr1013]=[AFTI_PROD].[dbo].[fnGET_JOURNAL_ENTRY]((2644),[Expr1016],[AFTI_PROD].[dbo].[T_EQUIPMENT_LOG_DATA].[READ_DATE])))

|--Sort(ORDER BY:([AFTI_PROD].[dbo].[T_EQUIPMENT_LOG_DATA].[READ_DATE] ASC))

|--Compute Scalar(DEFINE:([Expr1014]=CONVERT_IMPLICIT(decimal(19,5),[AFTI_PROD].[dbo].[T_EQUIPMENT_LOG_DATA].[READ_VALUE],0)))

|--Nested Loops(Inner Join, OUTER REFERENCES:([AFTI_PROD].[dbo].[T_EQUIPMENT_VARIABLE].[EQUIP_VARIABLE_ID]))

|--Hash Match(Inner Join, HASH:([AFTI_PROD].[dbo].[T_VARIABLE_GROUP].[FLOW_VARIABLE_ID])=([AFTI_PROD].[dbo].[T_EQUIPMENT_VARIABLE].[EQUIP_TYPE_VARIABLE_ID]), RESIDUAL:([AFTI_PROD].[dbo].[T_EQUIPMENT_VARIABLE].[EQUIP_TYPE_VARIABLE_ID]=[AFTI_PROD].[dbo].[T_VARIABLE_GROUP].[FLOW_VARIABLE_ID]))

| |--Compute Scalar(DEFINE:([Expr1015]=CONVERT_IMPLICIT(decimal(18,0),[AFTI_PROD].[dbo].[T_EQUIPMENT].[EQUIPMENT_ID],0)))

| | |--Nested Loops(Inner Join, OUTER REFERENCES:([AFTI_PROD].[dbo].[T_EQUIPMENT].[EQUIPMENT_ID]))

| |...

I would not change the timing of your log backups at all - keep running them every hour. Think about how you would recover your system to the point...

Actually the latter, the full backup does...

Hi Tom

Yes we did a full restore from a backup of the databases. FYI, the database .bak files before and after we're exactally the same file size. I'm not sure...

Hello everyone,

Here is a final update. We have resolved the performance problem by reinstalling SQL Server on the production machine. The server was reinstalled with SP3a. We ran the test...

New Update:

It looks like getting in a secondary server is on hold at the moment, so I won't be getting my hands on the prod server any...

Hello everyone,

heres an update on what I've been doing.

I've updated the statistics on the prod server and verified that the (text) execution plan is identical to dev. But I still...

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...

Hi Tim, thank you for your help.

I've checked both execution plans and they are the exact same.

I'm going to try to use perfmon to see if I can find...

Here is the queryplan. This query is very complex as you can see. Is there a way you also display performance statistics?

       |--Sort(ORDER BY[Union1170]...

Hi guys

Thanks for the promt reply.

Sql server is set to dynamically configure its own memeory. It has access to all 2gb of memeory. Generally sqlsevr.exe takes about 700mb's, and at...