Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » MAXIMUM instance
Add to briefcase

MAXIMUM instance Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Nero-1119276
Posted Tuesday, June 23, 2009 11:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 29, 2009 6:31 AM
Points: 39, Visits: 132
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
Post #740758
Eswin
Posted Wednesday, June 24, 2009 12:09 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:56 AM
Points: 1,593, Visits: 1,026
SQL Server Standard edition includes the core database engine, along with the stand-alone services. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some high-availability functions such as hot-add memory (allowing memory to be added while the server is still running), and parallel indexes.

Try

select * from sysservers

you will get the list of servers and liked servers.

Tanx
Post #740778
Nero-1119276
Posted Wednesday, June 24, 2009 1:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 29, 2009 6:31 AM
Points: 39, Visits: 132
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 ATTRIBUTE
Thanks,
Neerav
Post #740808
GilaMonster
Posted Wednesday, June 24, 2009 1:27 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:20 AM
Points: 38,086, Visits: 30,382
neerav.saini (6/24/2009)
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 ATTRIBUTE


What attribute? I don't understand what you're asking.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #740814
Eswin
Posted Wednesday, June 24, 2009 3:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:56 AM
Points: 1,593, Visits: 1,026
what did you get when you gave

select * from sysservers

Tanx
Post #740844
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.