February 8, 2004 at 7:21 pm
What is a SQL Server Instance and how do I determine how many instances of SQL Server we have? Thanks.
February 9, 2004 at 5:23 am
An installation of the SQL executables which can be run independently in memory. You have at minimum 1 instance but can install more that can be run independently in memory. You find all usually you can either look under Services control panel or use PerfMon look at SQL counters and will list individual instances in most all cases.
February 9, 2004 at 7:47 am
Or simpler yet...
Open Enterprise Manager, expand the Microsoft SQL Servers, expand SQL Server Group. Anything under there is an instance.
The default instance will be servername
additional instances will be servername\instance_name
-SQLBill
February 9, 2004 at 8:23 am
The only problem is they do not always get attached to EM when installed. Not a guranteed place to see.
February 9, 2004 at 11:02 am
Antares has a good point. Thanks for pointing that out.
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply