Can you confirm that the databases are not auto-closing.  This would have the database close and release all resources when it is not being used.  When someone connects to the...

P.S. As technicians, we often forget Return on Investement (ROI).  Most of us work for organizations that must make a profit.

It is often cheaper to throw additional hardware at an...

I agree with KlK and Dave's suggestions to find out what your current bottleneck is, and if possible how close you are to other performance limits.  That said, there are a...

I would suggest making sure that AUTO_CLOSE is not set for the databases in question.  See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_6ohf.asp

Regards,

Mike

ISV - Independent Software Vendor

Microsoft SQL Server Runtime is a special licensing of SQL Server that is bundled with an application.  This version of SQL Server is only licensed for...

I believe you need to get a SQL Server license.  I base this belief on "as Runtime licenses may only be used with a given ISV's solution."  See http://www.microsoft.com/belux/nl/partner/isv/pip_faq_lic.mspx

It...

"OpenQuery needs metadata about the columns at compile time"

  http://support.microsoft.com/default.aspx?scid=kb;en-us;297368

If you perform a Google search of Microsoft.com using the search criteria:

"object has no columns" "linked server" site:microsoft.com

You will...

Hi bj007,

"Is there something i am missing.."

After you click on the fourth button, "View Log File Data" or CTRL-L, you should all all of the instances of all of...

FWIW, I would suggest using Perfmon to convert the saved binary file to a comma seperated file.

1. Open the binary file (.blg) in Perfmon.
2. Add all counters of all of the performance objects...

... And if the database has been set up for replication, you get additional system tables (e.g., sysarticles, etc.)

Cheers,

Mike

I apologize, some extraneous characters were appended to the link.

http://download.microsoft.com/download/9/b/4/9b45acbc-9efc-4075-ad1e-6f05474619d0/SQLServer2000andItanium2-byScalabilityExperts-Rev3.ppt

According to the PowerPoint presentation "Limits of the 32-bit Environment" (http://download.microsoft.com/download/9/b/4/9b45acbc-9efc-4075-ad1e-6f05474619d0/SQLServer2000andItanium2-byScalabilityExperts-Rev3.ppt&e=42), the procedure cache is limited to 4 GB, but "Practical limit is less than 3 GB".

(Watch...

Hi,

When performing a two computer upgrade from SQL Server 6.5 to SQL Server 2000, the account used for the MSSQLSERVER service on both machines should be domain accounts belonging to...

Hi Raj,

First step you will need to define your requirements.  I suggest reading "Introducing Replication" and "Planning for Replication" in BOL.

Once you have your requirments an have planned how you...

If you look closely, when you use EM to change the Network Configuration, the window that opens is "SQL Server Network Utility".

Cheers,

Mike