Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Maximum instance

Author  Topic 

neerav.saini
Starting Member

9 Posts

Posted - 2009-06-24 : 01:10:04
Hi all,
Can anyone tell me?
In Sql Server standard edition
1.How many MAXIMUM instance can be run?
Query to find no. of instacne running?
2.what are attributes?



Thanks,
Neerav

Directory
Starting Member

5 Posts

Posted - 2009-06-24 : 01:52:14
What do you mean?

Is it server instances or table instances can be run in query?
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-24 : 02:02:20
see http://msdn.microsoft.com/en-us/library/ms143432.aspx

quote:
50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

SQL Server supports 25 instances on a failover cluster.



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

neerav.saini
Starting Member

9 Posts

Posted - 2009-06-24 : 03:16:36
hi,
It is server instance.
Actually i was facing some problem mentioned in forum named "SLOW DATABASE".
To get over problem we have to delete some data but this problem will come again when space fills
i am using sql server standard edition.
ON internet i was able to trace information regarding number instance and sizing except attribute list
CAN ANYONE SEND ME LINK OR POST LINK TO GET LIST OF ATTRIBUTE
Thanks,
Neerav

Thanks,
Neerav
Go to Top of Page
   

- Advertisement -