SQLServer - Memory

Question

Post reply

SQLServer - Memory

ravisamigo

SSCertifiable

Points: 7440
More actions
November 29, 2010 at 3:40 am

#146380

Dear All,
Can some one advise me on the below?
How to find the Total memory using by SQLServer through SQL query?
Thanks and Regards,
Ravichandra.

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

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

Marco V SSCrazy Points: 2939 More actions · Answer 1

http://sqlserverpedia.com/wiki/Current_Memory_Use_By_SQL_Server

Adiga One Orange Chip Points: 27284 More actions · Answer 2

Hi Ravichandra,

This article[/url] also explains it nicely.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

ravisamigo SSCertifiable Points: 7440 More actions · Answer 3

Dear Pradeep,

Thanks.

When I ran a the below query on two different servers I got the below result.

Please advise why it's showing different product versions for SQLServer 2005 ServicePack 3? and also let me know the latest service pack in 2000,2005 and 2008.

select serverproperty('productversion')

select serverproperty('productlevel')

select serverproperty('edition')

Server 1

-----------------

9.00.4053.00,SP3 and Standard Edition

Server 2

-----------------

9.00.4035.00,SP3 and Standard Edition

Thanks and Regards,

Ravichandra.

Adiga One Orange Chip Points: 27284 More actions · Answer 4

Please go through this site. It answers all the above questions.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga