Thanks,

I got it.. for Biztalk server databases in sql server these 2 otions should be OFF by default..

From BOL:

Auto Update Statistics/Auto Create Statistics:

The Auto Create Statistics and the Auto Update...

Thanks collin,

We would set the max server memory to a fixed value rather than the default settings, But what about the page file size?we have 2GB page file size, Is...

We did not enable the lock pages in memory and the default pagefile size 2GB?

What are the settings do I need to change?

Yes, we went through this link, but did not get any clue...

thanks

Hi,

We have SQL Server 2005 EE x64 with SP2. So far we did not applied any cumulative updates.

In this case can we directly apply SP3 over SP2?

and why we do...

thank you,

If choose to install option 2, there is no need to install option right?

correct me if Iam wrong..

No, Autoshrink for the database is set false.all options are set to default values

thank you

thanks,

Select @@version

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Thank you..

We have SQL Server 2005 EE x64 with SP2 installed....So this configuration still We have any concern with maintenance plan as I explained in my case...

Thanks for your help

I do not have any backup for Test database. I need to take the backup now and delete it.

thanks,

the sharepoint application databases are sitting in the SQL Server. So where can I use this Connection pooling?

Its a SQL Server 2005 EE 64 bit. The memory settings are set to default values. We did not change the default values

thanks

"Just bear in mind that you would have to use a named instance of SQL2005 (if you are using the default instance of SQL2000), and you must be running a...

No, we are decided to do after office hours..

thank you