June 23, 2009 at 11:12 pm
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
June 24, 2009 at 12:09 am
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 😀
June 24, 2009 at 1:15 am
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
June 24, 2009 at 1:27 am
neerav.saini (6/24/2009)
ON internet i was able to trace information regarding number instance and sizing except attribute listCAN 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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2009 at 3:28 am
what did you get when you gave
select * from sysservers
Tanx 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply