Memory Settings In SQL Server 2005 Standard Edition
Hi,
I'm having trouble finding the optimum memory settings for SQL Server 2005. I have 4 instances running on a macine with 8 dual-core processors and 18GB of RAM. I have tried the following memory settings so far:
No maximum - one instance used about 12GB of RAM so then the others struggled
Maximum of 4GB each (2GB left for Windows) - meant that 3 instances could be using 1GB each and then another at 4GB and needing more whilst 9GB sat unused.
Minimum of 2GB each - one instance would use up 10GB and then never give any back to the other instances.
I also find that setting a maximum then just causes a high amount of paging. What I would like to do is have each instance use a minimum amount, say 1GB, and then have each instance use a maximum of 13GB (3GB for other 3 instances running at a minimum level and 2GB for Windows). This 13GB should then be released and allocated to another instance when necessary, assuming it is no longer all being used. I do not want paging to occur if an instance reaches 13GB.
How do I go about configuring SQL Server to behave like this? Is it possible?
Thanks.
View Complete Forum Thread with Replies
Related Forum Messages:
Installing SQL Server 2005 Enterprise Trial Edition And Standard Edition On Same Machine
Hi -I have istalled sql server 2005 standard edition , I want to install sql server 2005 enterprise edition on the same machine. Is it possible? I have Microsoft windows server 2003 SP2 and 1GB RAM. I want to use partition function with the enterprise edition, will the trial version of sql server work for me? -If I have already created a database and tables using the standard edition, will I be able to access and use the database using the installed trial version or will I have to start a fresh creating a new database? - Is it possible to access the same database with any of the installed versions? BTW, I am prety new to sql server and databases , I am trying to learn by myself Thanks
View Replies !
Performance Difference Between SQL Server 2005 Standard Edition And Enterprise Edition
Dear All,We have a database which contains many tables which have millions ofrecords. When We attach the database with MS SQL Server 2005 StandardEdition Server and run some queries (having joins, filters etc.) thenthey take very long time to execute while when We execute same querieson Enterprise Edition then they run 10 times faster than on standardedition.Our database does not use any features which are present in EnterpriseEdition and not present in Standard Edition. We want to know what arethe differences between Standard Edition and Enterprise Edition forperformance. Why should we go for Enterprise Edition when StandardEdition has all the features required.We are presently using evaluation versions of SQL Server 2005 Standardand Enterprise Editions.Thanks and regards,Nishant Sainihttp://www.simplyjava.com
View Replies !
Error Upgrading SQL Server 2005 From Standard Edition To Enterprise Edition (x64)
I am attempting to upgrade a 2005 Standard Edtion to Enterprise Edition. This is a default instance. All components are upgraded successfully except the Database Engine. I receive the following error: SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]The certificate cannot be dropped because one or more entities are either signed or encrypted using it.. To continue, correct the problem, and then run SQL Server Setup again. This installation does not have encryption enabled, so I do not undersand the error or how to correct it. After rebooting the SQL instance appears to be upgraded to Enterprise, but it cannot be upgraded to SP2. Thanks,
View Replies !
SQL Server 2005 Workgroup Edition Upgrade To Standard Edition
I'd like to upgrade from my current SQL Server version: 09.00.3042 (Workgroup edition that comes with SBS upgrade) to the standard edition that I've just purchased. I've attempted to run setup.exe SKUUPGRADE=1 from the command prompt and it just tells me that there's nothing new to install. I don't really want to uninstall the current installation just to do something that shouldn't be complicated to do, upgrading software versions should not be a difficult process. Does anybody have any experience with this?
View Replies !
Replicating From SQL Server 2005 Standard Edition To Remote SQL Server 2005 Express Edition
Hello, I have been unable to create a replication from an SQL Server 2005 standard edition database to remote SQL Server 2005 Express Edition. The remote express edition is on a Virtual Private Server we are leasing from a hosting company. The name of the remote DB is similar to vs572.si-vs572.com. I can connect to this with SQL server authentication through Management Studio and also with SSIS. But, I have been unable to create a push subscription (I have tried a test push subscription with the same publication to a local SQL Express server here in our office and this works fine). Here is the error message: SQL Server Replication requires the actual server name to make a connection to the server. Connections through server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'VS572SQLEXPRESS'. The hosting company had originally installed a shared SQL server which would not support replication. They then installed SQL Express edition and I was hoping this would allow us to run a replication. I tried to connect to VS572SQLEXPRESS with out any luck. I check the remote connections, made sure replication was installed, etc., but no luck. Any help would be greatly appreciated! Thank you, Albert
View Replies !
How Can I Run SQL Server 2005 Developer Edition On Standard Edition
I tried to download PerformancePoint Server Trial Version to ther server today and I got to the configuration point of the Analysis Services Setting, and when I clicked next to proceed with the configuration I got a popup error message: "Microsoft Analysis Server must be Evaluation, Developer or Enterprise Edition". Now I have SQL Server 2005 Developer Edition Disc (Bought it with Visual Studio 2005) but on the server I have SQL Server 2005 Standard Edition, if I try to run the sql server developer Edition disc, I use the wizard download and it seems that the download is going through the SQL Server entire download, it's like I'm re-downloading SQL Server all over again. Does that seem right? what is the best approach to work around this probelm? I appreciate any help Thanks
View Replies !
Max. Memory Supported By Standard Edition
I learned that SQL2000 Standard Edition can only support up to 2GB RAM, we have a WIN2K system on a server with 4CPU, 4GB RAM, if we run SQL2000 Stanard Edition on it, will the 2 extra 2GB of RAM be wasted ? Since there is a big diff. between licensing cost of SQL Standard and Enterprise, that's why the user choose Std. edition. Any opinion or comment...
View Replies !
SQL2000 Standard Edition Only Uses 1.75GB Memory
Our production server has 3.3GB of memory and is running Windows 2000 server(service pack 2) and SQL 2000 Standard Edition(service pack 1). We have configured SQL to use the maximum memory for standard edition (2GB) In use, however, task manager shows SQL is ONLY using 1.75GB maximum memory Our database size is 11Gb and we would expect to see SQL using the FULL 2GB I have heard a similiar story from a colleague at another installation.. Does anyone have any insight into why this would be the case?
View Replies !
MS SQL Server 2005 Standard Edition
I have the option of buying a new copy of MS SQL Server 2005 Standard Edition for Itanium based systems, however will this also work on the following spec server 2.8Ghz P4 1Ghz Ram 120Gb IDE hard drive with windows 2003 standar edition operating system The part number for the stanard edition of SQL is 228-04025 If it helps you can call me on +44 (0) 1285 644091 Thanks Simon
View Replies !
Need Help In Configuring SQL Server 2005 Standard Edition
Login failed for user ''. The user is not associated with a trusted SQL Server Connection. Ive got this error... I have just installed the SQL Server 2005 Standard Edition. Could anyone encounter and solve this problem.. please til me how to solve this. I google this but couldnt find a reliable solution for this.. Thanx...!
View Replies !
DB2OLEDB For SQL Server 2005 Standard Edition
The Microsoft OLEDB provider for DB2 (DB2OLEDB) is available in the "Feature Pack for SQL Server 2005 €“ April 2006." The installation routine, however, will only install on the enterprise edition or the developer edition. Is the DB2OLEDB provider not available for SQL Server 2005 standard edition?
View Replies !
No Server Instance In SQL 2005 Standard Edition
Good day! I installed SQL 2005 Standard Edition in my XP machine, but I don't have any instances. When I use Add/Remove programs, and click Change in Microsoft SQL Server 2005, it says that "No instances have been installed. To add a new instance, click the Add component hyperlink", but I cannot see the hyperlink. Why was the default instance never installed? How do I install a new instance? Thanks.
View Replies !
MS SQL Server 2005 Standard Edition IA64 With 5 CLT
Hi, I have the option of buying MS SQL Server 2005 Standard Edition IA64 with 5 CLT part number 228-04025, however will it work on the following spec server; 2.8Ghz P4 1Gb Ram 120Gbide hard drive running Windows 2003 standard edition If it helps you can call me on +44 (0) 1285 644091 or simon@310k.co.uk Thanks Simon
View Replies !
SQL Server 2005 Standard Edition Licensing
I'm getting some conflicting information , regarding sql 2005 Standard Edition licensing for multi instancing. If you have multiple instances of SQL 2005 Standard Edition on one Server, do you need to pay a server license for every Instance or just the one Server license? Jack Vamvas -------------------- Search IT jobs from multiple sources- http://www.ITjobfeed.com
View Replies !
How To Make Use Of 4 GB Memory For SQL Server 2005 Standard + Windows 2003 Stardard
We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory? Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005?
View Replies !
Upgrade From SQL Server 2005 Eval Copy To SQL Server 2005 Standard Edition
I have a SQL Server 2005 evaluation that has already been installed and setup on a server. I believe it originally had a 180 day eval. There have been numerous databases and users added as well as maintenance plan created... The eval was put on the machine as an interim solution while waiting for paper work and order processiing things to happen. All the paperwork and ordering... have been completed and I now have the real SQL Server 2005 Standard Edition license key .... I am very new to SQL Server and need to determine ... 1. Can I update the eval copy to become permanently licensed? 2. Would I want to upgrade the eval to permanent? Will I lose any capabilities by keeping the current eval setup? If it is reasonable to keep the eval setup 3. How do I go about entering the license key to make it permanent? If it is necessary to install the new Standard Edition... 4. How do I install it while maintaining the already defined databases, data, users, maintenance plan... Thanks in advance for any and all help. Chris
View Replies !
Server Name Issues In SqlServer 2005 Standard Edition
Hi everyoneHere's the situation:I'm just a liitle confused on how Sql Server 2005 manages permissions.What does it use and where : the computer name or the user name?Basically, where does it get the server name from? And why does SqlServer Express Edition use the server name "somethingSQLEXPRESS" ?
View Replies !
Sql Server 2005 Standard Edition Install Problem
I am planning to work with replication topic and i have a problem with it. I have installed a SQL server 2005 standard edition.When i try creating a new publication it comes out with this error "Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of sql server. for information about installing replication,see installing replication in sql server books online Additional information: Execute permission denied on object 'sp_MS_replication_installed",database'master',owner'dbo'. (Microsoft SQL server ,Error:229) I have tried inserting the CD and reinstalling it.but didnt work. When i tried to Remove sql server from control panel add/remove programs it shows me the following components to be deleted.but then even after restarting my machine i find everything in start->all programs. what do i need to do?? Please help me.
View Replies !
SQL 2005 Standard Edition - Licensing Question For Web Server
I have one server hosting an ASP.NET application. It will be running 2005 Standard Edition. I don't really understand which licensing model I need. Obviously processor licensing would work, but at a hefty price! The web application and SQL Server are on the same machine, and no other machines will be querying the database. The only 'users' are the people who visit the website (both internal and external users). Can someone help me properly determine the most cost efficient licening model to use? Thanks
View Replies !
Processor Limit In SQL Server 2005 Standard Edition
I am looking at running SQL Server 2005 Standard Edition in a clustered environment (2 nodes) and am not sure if the 4 processor limit applies to the number of processors per node or the number of processors it will run on in the entire cluster. Could someone please clarify this for me?
View Replies !
SQL Server 2005 Standard Edition Installation Issues
I've installed this applicaton many times, however, while setting up a new virtual server for TFS, the person installing the server piece didn't choose the appropriate security mode to use when logging in. Due to this, we attempted to reinstall the management studio and the installation keeps failing. We've hit many challenges up and includig using the original cd's instead of an install from a network location. When attempting to install it fails, when we put the error into help, there isn't any help on the topic. We have managed to install everything except XML and management studio. The studio I can go without, but TFS needs the XML piece. Any ideas?
View Replies !
Problem With SQL Server 2005 Standard Edition Installation
Hello, When I try to install SQL Server 2005 Standard Edition, Windows XP SP2, setup fails. Please help!!! This is log file: .............................. Loaded DLL: C:Program FilesMicrosoft SQL Server90Setup BootstrapDbgHelp.dll Version: 6.5.3.7 MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6010) of type 790531 for thread 2260 MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6009) of type 790540 for thread 2260 MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6008) of type 790541 for thread 2260 MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (5973) of type 790541 for thread 2260 MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (5970) of type 790531 for thread 2260 MSI (s) (98:E8) [12:19:07:890]: Note: 1: 2769 2: Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2 3: 5 Info 2769.The installer has encountered an unexpected error. The error code is 2769. Custom Action Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2 did not close 5 MSIHANDLEs. MSI (s) (98:2C) [12:19:07:890]: Machine policy value 'DisableRollback' is 0 MSI (s) (98:2C) [12:19:07:890]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionInstallerRollbackScripts 3: 2 Action ended 12:19:07: Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3. MSI (s) (98:2C) [12:19:07:890]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionInstallerRollbackScripts 3: 2 MSI (s) (98:2C) [12:19:07:890]: No System Restore sequence number for this installation. MSI (s) (98:2C) [12:19:07:890]: Unlocking Server Action ended 12:19:07: INSTALL. Return value 3. Property(S): ProductCode = {28B22773-100E-4AF2-A1C9-2F2EA8A35844} Property(S): ProductLanguage = 1033 ------------------------------
View Replies !
SQL Server 2005 Standard Edition - Installation Media
Hiya, We were recently let down by our software supplier who have happily provided us with a single processor license for SQL Server 2005 before the weekend.. but haven't been able to provide any installation media. I notice on the website that there is a trial edition of the Enterprise edition for download, that can be converted into a full installation by using a valid license key. My question is.. would I be able to use that trial edition with my license key? Or are they fundamentally different? If that isn't an option.. is there anywhere where I can obtain installation files for standard edition? Thanks in advance, -- Tim
View Replies !
SQLEXPRESS Instance On SQL SErver 2005 Standard Edition
What happens when you install a SQLEXPRESS instance on a machine that already has SQL Server 2005? Will the SQLEXPRESS still run in the limited mode or will it sense that an full standard version of SQL Server 2005 is already present and just "upgrade" itself? On the otherhand, how do I "upgade" an existing instance of SQLEXPRESS to a full version of SQL Server 2005 standard edition without uninstalling and installing the standard edition. If I have both the instances then will the SQLEXPRESS be freed from its limits? Thanks, Vikram
View Replies !
Changing License Key In SQL Server 2005 Standard Edition 64-bit
Hi, I need to install Microsoft SQL Server 2005 Standard Edition 64-bit running on Windows Server 2003 R2 Standard Edition 64-bit. Instead of installing it on every single machine I thought of installing it on one of them, updating it with all the necessary updates, creating a ghost image of the updated system and database and copying the image on all the other machines. After doing it I however need to update both the system and SQL Server license keys. And there comes my question whether one can change the SQL Server license key after the installation?? Thanks in advance
View Replies !
Upgrade From SQL Server 2005 Developer To Standard Edition?
Hi, Has anyone tried an in-place upgrade from SQL Server 2005 Developer to Standard Edition? It apears to be a valid upgrade path according to this: http://msdn2.microsoft.com/en-us/library/ms143393.aspx Is it just a case of changing the registered licensing info? (I presume all the functionality for Standard exists in the Developer Edition) Or is it a reinstall job? I want to use a dev license for development on the server, then once its finished, just leave it in place on the box and upgrade the licensing to standard edition. (The client doesn't yet have a Standard License, but does have a Dev License - and wants me to start right away!) If its going to boil down to having to do a full re-installation then I should get a Standard license from the start, if its just a minor license key change, then I can use a Dev license straight away! Pls. help. Thank you!
View Replies !
SQL Server 2005 Standard Launch Event Edition
I have a Question about this Version! Is this true that only one Person can query the Server at the same time? ( 1CAL Lizense) I wrote a .Net Appllication and now the Appllication need acces to the Server to Query Tables. In the "Rush Hour" it is possible that more than 100 Person make Querys from that Application to the SQL Server at the same time. I don´t understand the CAL Lizens because the SQLServer Express allows up to 20 connection!? The SQLExpress is for free and allow more connections than a paid Version? Or is a difference between connection ( through the Appllication) and Connection through the Management Studio ? Thanks for HELP!! Pseudocode
View Replies !
2005 X64 Cluster - Memory Settings
So I'm in the middle of building SQL Server 2005 on my new cluster hardware. I've got all the goodies this time around -4x PowerEdge 68004x dual core x64 procs in each box32GB ram in each boxWindows Server 2k3 R2 Enterprise x64 SP2SQL 2005 Enterprise x64 SP2Active Active Active Passive cluster (4 boxes, 3 instances)dedicated data, log, and tempDB 4Gb 15k fiber channel SAN Volumes for each instanceNow, this is the first x64 box I've configured, so I'm looking for some optimization tips for a couple things.First one's memory. On our 32bit systems, I always added the /PAE switch to the boot.ini file and enable AWE in SQL Server. From what I'm reading, that's no longer needed with the enhanced memory addressing. Is that the case? Is there an MS best practices KB doc in regards to configuration? I can't find one.Also, should I set anything special pagefile-wise? I know the old mantra is 1.5x system memory, but that would create a 48GB page file. Our current cluster has 6GB of ram dedicated to each instance (2k) and Perfmon tells me it's barely touching the pagefile. I'm thinking of just leaving it default, but I want to know if there is a best practice that I'm missing. Again, I can't find an MS doc that addresses this particular scenario.
View Replies !
Win03, SQL 2005 And Memory Settings.
We have two servers needing to proper configure memory. They are dedicated SQL servers. Server1(S1) Win03 EntR2 sp1 w/8gb ram, SQL2005 Ent sp1 Server2(S2) Clustered Win03 EntR2 sp1 w/16gb ram, SQL2005 Ent sp1 I am confused on the settings for each server to maximum memory use. I gather on each need to allow the service acct right to €œlock pages in memory€? S1- What switch needs added to the boot.ini? (just /pae or add /3g) Enable AWE in SQL? Set max mem to 7gb? S2- What switch needs added to the boot.ini? (just /pae or add /3g) Enable AWE in SQL? Set max mem to 15gb?
View Replies !
SQL Server 2005 Standard Edition And Website Starter Kits
Hi, everyone! I'm trying to practice with the website starter kits using Visual Studio 2005. But so far, I haven't been able to run the mentioned websites because the connection they use is against SQL Server Express... I don't have SQL Server Express. Instead, what I have installed is SQL Server 2005 Standard Edition. I'm not even able to use the new APS.NET WeSAT application to administer the sites because allway get the "Time out" error. Do any of you know how to resolve this whole situation? Thanks very much in advance for your help. Ralph.
View Replies !
List Of Supported Components For SQL Server 2005 Standard Edition?
Please can someone give me a url or even their own list of support / unsupported components in SQL server 2005 Standard edition. I know fuzzy lookup is not supported. Is a slowly changing dimension supported? Its a bit difficult to tell when I get bizzare "Product level is insufficient" error for even a basic derived column transformation when executing a package using SSIS unless it is executed using a scheduled job.... thanks, Nicole
View Replies !
SQL Server 2005 Standard Edition Install Fails; An Instance With The Same Name.../
Good Morning I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled. I have selected the default instance and everything I try results in the error: An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. Log file says; -------------------------------------------------------------------------------- Machine : ISAINTERNET Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ISAINTERNET_SQL.log Last Action : DetectInstanceClash Error String : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. Error Number : 28086 -------------------------------------------------------------------------------- Ian Smith
View Replies !
Upgrading MS SQL Server 7 SP4 Standard To 2005 Enterprise (Eval Edition)
Hello, you all, I did all the stuff necessary for the upgrading (the Upgrade Advisor didn't say anything special), but the Setup says the following: " Name: Microsoft SQL Server 7.00.1063 Cause: The update is blocked. You can obtain more informations in the online help "Versions- and editionsupdates". Editions problem: The update is blocked because of rules for the editions update. " Is it possible that an upgrade is not possible with the evaluation edition? Or can there be another cause? Thanks in advance Oliver
View Replies !
Problem With Remote Connections With SQL Server 2005 Standard Edition
After applying the changes mentioned in KB 914277 to allow remote connections, while working in Visual Studio 2005, I'm now getting an error with the number 26: Error locating server/Instance specified... Sure wish I knew what remote means in this scenario, as there is nothing "remote" about my installation. I only have 1 computer, the one i'm working on, where SQL Server and Visual Studio are installed, and no networks involved, so what is remote? Any help would be appreciated!!
View Replies !
Downgrade Path From SQL 2005 Enterprise Trial Edition To Standard Edition
Hi all--I'm researching the cleanest downgrade path from a trial edition of SQL Server 2005 Enterprise to a licensed Standard Edition copy. It looks like downgrading will entail uninstalling the old version and installing the new version, but I'd like to save the original setup as much as possible. Detaching the old databases will preserve the non-system databases; what method would work best for restoring the system databases? Thanks! - Jon
View Replies !
Installing SQL Server 2005 Standard Edition When Express 2005 Is Already On Server
I need to install SQL Server 2005 Standard Edition on a new Windows Server 2003 machine that has SQL Server 2005 Express Edition installed by a backup application (Backup Exec). Will I need to uninstall the express edition in order to install the standard edition? Can the two coexist as separate instances or will the standard edition installation simply upgrade the express installation? Thanks
View Replies !
Product Key For SQL Server Standard Edition 2005 Via Open License Agreement
Hi, I have a customer, Customer who has purchased SQL Server Standard Edition 2005 via Open License Agreement. The product key is not available with the media. I checked with eOpen team and confirmed that SQL 2005 does not require product key or Volume License Key for installation. however, according to the VKB article 331355 titled "eOpen License Web Site" under "Exceptions" it is mentioned as: SQL Server: The product key is distributed with the media. If the customer did not get a product key with the media, refer them to their reseller. The product key is hidden between two shrink-wrapped CDs. Need your clarification on this, How should we provide the key to the customer. Thanks, Jagdeep
View Replies !
|
TRACKER
