Hi,

You can create non-clustered (not unique) indexes, and can improve performance.

If you change the setting from ANSI NULLS OFF to ON, you need to do Regression Testing.

In my opinion, ANSI...

Please make sure if you have configured memory settings for SSRS in RSReportServer.config file.

For example(sample values only):

<MemorySafetyMargin>80</MemorySafetyMargin>

<MemoryThreshold>90</MemoryThreshold>

...

From the view of database architect, sending emails is a business functionality and need to be hosted in a separate server as separate application! The application needs to read sqlserver!

Thanks everyone...

I started collecting server side trace and DMV.

Regards,

Prakash.

Hi,

It is production environment, so I can not execute the stored procedure.

I can not view the estimated execution plan for the SP.

Msg 208, Level 16, State 0, Procedure usp_GetData, Line...

Try something like this!

DECLARE @account varchar(100)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

@account OUTPUT,

N'no_output'

SELECT @account as SQLServer_ServiceAccount

Regards,

Prakash.

Hi

Check the following

Improper Indexes / No Indexes

Locks

Blocking

Select queries with larger resultset

We can have scripts to monitor objects inside databases.

But how can we informed if the sqlserver instance is stopped or sqlserver agent is stopped?

This is the biggest problem we face.....

R.Prakash

very urgent means "I have to complete replicating fields by today".

Great Info!

Thanks a lot for your explanation.

Regards..

I have the license keys, How can I use it to download the software?

Regards,

Prakash

Thanks for your information.

I got it worked.

Regards,

Thanks Jason, That works greatly!

Thanks Carol, That will save my major work time.

past 24 hours means in the same day.

Your query helped me a lot ... This is what i wanted.

Thanks