Thanks for the response

But my object explore font is not default one so, i cannot able to see objects. so, help me on this.

Thanks,

KK

Read Committed Isolation Level

--KK

Then you have to enable Auto Shrink option in Server.

But this will impact on server/DB performance.

Instead of enable Auto Shrink avoid to use temp tables for large amount of data/records.

Thanks,

KK

I cannot start Trace or sql profiler because it is production.

when i test same in test environment no issues.

we are getting issue during the users(thousands) are using...

Thanks Adi,

What i am looking exactly is,

We have found few deadlocks during the application is in use. To identify these deadlocks i have written even handler to find procedure...

in above thread provided information is taken from .log.

Thanks,

KK

SQL server exists in C Drive. So, by the default we are not changing any installation path of sp2.

Thanks,

KK

Thanks, I got it.

KK

where the backup has taking that server is not with us. We have only .bak file

Thanks,

Kishore KK.

Hi Chris,

Thanks for the update.

My table having indexes, normalization and all other statistics are good.

But we are facing a latency when we are using this table in joins....

If you are confident the sql statement will return one row, then you can capture the values in variables.

If more than one row the last row info will available...

Thanks for the update.

In your Image just look there is a Login "sa" is not showing connected database information.

That is what i need. If i want to...

What's the table schema?

CREATE TABLE [dbo].[FDDB](

[FDD_ID] [int] IDENTITY(1,1) NOT NULL,

[DETAIL_ID] [int] NOT NULL,

[EFFECTIVE_PERIOD_ID] [smallint] NOT NULL,

[PERSPECTIVE_ID] [smallint] NOT NULL,

[TYPE_ID] [smallint] NOT NULL,

[SCENARIO_ID] [smallint] NOT NULL,

[VALUE] [numeric](19, 6) NULL,

[AUDIT_ID] [int] NOT...

performance degraded means "while downloading a report from application"

before compression 2 minutes 48 seconds

after compression 3 minutes 42 seconds.

How can i improve performance with compression?

one clusterd and one non...

But when i execute these two statements

getting irrelavent information in second select(???????)

can you give more or refferences to get analyze my expectations.

Thanks

Kishore KK.