Limiting the maximum memory used by SQL Server 2005

September 14, 2009

A great tip for limiting the maximum memory used by SQL Server 2005 when you are hard pressed for resources is to limit the maximum memory threshold of SQL server of your SQL server instance.

This can be acheived easily by setting the “Maximum Server Memory” setting in your SQL Server instances properties.

sql2005-properties

This improved performance for me within my development virtual machine.


How do I: Install the UDDI services database components on a SQL2005 instance.

August 9, 2009

When installing UDDI services database components onto your SQL2005 instance you may receive this error:

The database instance does not meet the minumum version or service pack level requirements...

The database instance does not meet the minumum version or service pack level requirements...

This issue occurs because the UDDI installation process examines the value of the CSDVersion registry entry for SQL Server. The CSDVersion registry entry is used for SQL Server 2000 service packs. The CSDVersion registry entry is not used for SQL Server 2005. Therefore, this version check fails when you try to install the UDDI Services database components on an instance of SQL Server 2005.

To fix this you can follow the steps outline in this Microsoft Support document http://support.microsoft.com/kb/927230 or cut and paste the following script into a blank text document and save as a batch file.

@echo off
setlocal
if {%1}=={} goto defi
set ni=%1
set ni=%ni:”=%
set key=”HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\%ni%\MSSQLServer\CurrentVersion”
goto getver
:defi
set key=HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
:getver
set cv=0.0
for /f “Tokens=2*” %%a in (‘reg query %key% /V CurrentVersion^|find /i “REG_SZ”‘) do (
set cv=%%b
)
@echo reg add %key% /V CSDVersion /T REG_SZ /F /D “%cv%”
reg add %key% /V CSDVersion /T REG_SZ /F /D “%cv%”
@echo After installing the UDDI Services database components, run the following command:
@echo reg delete %key% /V CSDVersion /F
endlocal

After running this batch file re-attempt your UDDI services installation and you will be able to install your UDDI services database components to your SQL2005 instance.