instances,harddisk

Question

instances,harddisk

nikki123

Ten Centuries

Points: 1338
More actions
December 9, 2009 at 8:31 am

#135810

how do i determine the no of instances on sql server unding t sql or anyother method . and how do i know total size of harddisk .
please let me know

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

Is it an Interview question?

If you have Server access, then a quick check in the SQL Server COnfiguration Manager would let you know, and Windows Explorer would help.

If you are trying to figure this out for some reason, I suggest first try searching in Google and if not found post a question.

If you already found something, and tried it and running into problems, post it here, would get plenty of responses.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

To find the number of instances open the SQL Server Configuration Manager and count the number of Database Engine services listed. You can also find it out by looking at the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL

You can get the disk information by hooking COM with OLE Automation from TSQL following the example on this article:

Disk Space Monitoring

If you just want numbers, open up the Disk Manager on the server and you can see the physical volumes, how the logical partitions are mapped to physical volumes, size infromation, and free space information in one quick view. This is all handled via WMI so you could also write a VBScript that queries WMI to gather this information as well. In fact a google search would probably provide you that script for free.

seth delconte SSCertifiable Points: 6388 More actions · Answer 3

how do i determine the no of instances on sql server unding t sql or anyother method . and how do i know total size of harddisk .
please let me know

Wouldn't this show you all the local server instances?

select name from sys.servers where is_linked = 0

_________________________________
seth delconte
http://sqlkeys.com

nikki123 Ten Centuries Points: 1338 More actions · Answer 4

nikki123

Ten Centuries

Points: 1338

December 9, 2009 at 9:00 am

#1089940

Yes i got it . i just go it through sys.servers.

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 5

Seth Delconte (12/9/2009)
Wouldn't this show you all the local server instances?
select name from sys.servers where is_linked = 0

No it would only show the current instance, it wouldn't have the other installed instances on the server, at least not on either of my multi-instance machines.