Monday, March 26, 2012

How to determine server size!

Hi!
How can I determine the size of my server in sql server? Please help!
Thanks!Measurnig tape?
Seriously though...size of what? Databases, harddrives, RAM, eveything?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jenny" <sosa48@.hotmail.com> wrote in message
news:1163711468.558168.104810@.f16g2000cwb.googlegroups.com...
> Hi!
> How can I determine the size of my server in sql server? Please help!
> Thanks!
>|||Yes, the size of everything, so I can get one solid number of the whole
size of the server.
Thank you!
Kevin3NF wrote:[vbcol=seagreen]
> Measurnig tape?
> Seriously though...size of what? Databases, harddrives, RAM, eveything?
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Jenny" <sosa48@.hotmail.com> wrote in message
> news:1163711468.558168.104810@.f16g2000cwb.googlegroups.com...|||Find out how many jigabytes you have and multiply that number times three.
"Jenny" wrote:

> Yes, the size of everything, so I can get one solid number of the whole
> size of the server.
> Thank you!
> Kevin3NF wrote:
>|||SQL Server, I assume...2000 or 2005?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jenny" <sosa48@.hotmail.com> wrote in message
news:1163714621.207065.296280@.k70g2000cwa.googlegroups.com...
> Yes, the size of everything, so I can get one solid number of the whole
> size of the server.
> Thank you!
> Kevin3NF wrote:
>|||Yes, SQL Server 2005.
Thanks!
Kevin3NF wrote:[vbcol=seagreen]
> SQL Server, I assume...2000 or 2005?
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Jenny" <sosa48@.hotmail.com> wrote in message
> news:1163714621.207065.296280@.k70g2000cwa.googlegroups.com...|||A really rough hack at getting the size of all MDF, NDF and LDF files is:
Select sum(size), 'MB' from sysaltfiles
I don't have much experience in SQL 2005, so I assume this is the size of
the lhysical file, not the data in the file
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jenny" <sosa48@.hotmail.com> wrote in message
news:1163784398.735132.27890@.h48g2000cwc.googlegroups.com...
> Yes, SQL Server 2005.
> Thanks!
>
> Kevin3NF wrote:
>sql

No comments:

Post a Comment