August 20, 2009 at 11:24 am
Hi
I have 2 instances on my server.
a) Default Instance
b) Named instance ( Instance1)
Now i want to change the Instance1 to Instance2 ( say ) . I tried the below commands .
sp_dropserver 'Hostname\Instance1'
go
sp_addserver'Hostname\Instance2'
go
After this i restarted the Instance1 services but not able to connect to sql server using Instance2. It is still using old instance name for the connectivity . I tried @@server and that is showing the Instance2.
Please let me know where the mapping of Instance1 needs to be changed so that i can connect my SQL SERVER 2005 using new instance name. I have checked restarting machine also but in services.msc it is showing the old instance name.
Any help would be appreciated.
August 20, 2009 at 12:17 pm
August 20, 2009 at 10:17 pm
Yes , i tried using the options mentioned in that forum but no luck . Seems these options were valid till sql server 2000. For SQL SERVER 2005 do i need to need to uninstall and resintall instance to rename it ?
August 21, 2009 at 1:32 am
nikhil.verma (8/20/2009)
Yes , i tried using the options mentioned in that forum but no luck . Seems these options were valid till sql server 2000. For SQL SERVER 2005 do i need to need to uninstall and resintall instance to rename it ?
Yes. You cannot rename a sql 2005 instance. Why do you want to anyway? If it has many users, databases and plans on it why would you go to all that effort? There would really need to be a BIG reason to make me undertake this.
What you are essentially doing is removing SQL and then re-installing a new instance and then re-patching. And the fact that you have a default instance (which presumably you wish to keep), makes the whole task that bit mor risky!
Adam Zacks-------------------------------------------Be Nice, Or Leave
August 21, 2009 at 1:36 am
Network Error: duplicate post removed.
Adam Zacks-------------------------------------------Be Nice, Or Leave
August 21, 2009 at 1:40 am
Network Error: duplicate post removed
Adam Zacks-------------------------------------------Be Nice, Or Leave
August 22, 2009 at 1:10 am
Thanks for the reply !!!!! Well yes i do agree this should not be done in production where users and jobs are already placed. Actually server is totally new and there is no user database and jobs created as yet. So as per the requirement i was trying this. Now after this i am stuck up at one new point .
a) My SQL SERVER 2005 has 3 instances on one of the server . One instance is having sharepoint DB's in it . And other 2 instances are blank. Server has 3.75 GB of RAM . And my Memory utilization is showing continously > 95 %.
Can you please tell how much memory sql consumes with no activity on it. And how to check the exact memory utilization for all the instances with PERFMON.
August 24, 2009 at 7:24 pm
Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how much the mssqlserver service is currently using. This includes the total of the buffers committed to the SQL Server BPool and the OS buffers of the type "OS in Use".
The second counter, SQLServer:Memory Manager: Target Server Memory (KB), tells you how much memory SQL Server would like to have in order to operate efficiently. This is based on the number of buffers reserved by SQL Server when it is first started up.
If, over time, the SQLServer:Memory Manager: Total Server Memory (KB) counter is less than the SQLServer:Memory Manager: Target Server Memory (KB) counter, then this means that SQL Server has enough memory to run efficiently. On the other hand, if the SQLServer:Memory Manager: Total Server Memory (KB) counter is more or equal than the SQLServer:Memory Manager: Target Server Memory (KB) counter, this indicates that SQL Server may be under memory pressure and could use access to more physical memory. [7.0, 2000] Updated 5-25-2005
http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx
MJ
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply