Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServer - Memory Expand / Collapse
Author
Message
Posted Monday, November 29, 2010 3:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743

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.
Post #1027213
Posted Monday, November 29, 2010 3:57 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:51 AM
Points: 462, Visits: 517
http://sqlserverpedia.com/wiki/Current_Memory_Use_By_SQL_Server

Post #1027216
Posted Monday, November 29, 2010 4:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 30, 2014 8:52 AM
Points: 1,618, Visits: 20,966
Hi Ravichandra,

This article also explains it nicely.


Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1027224
Posted Tuesday, November 30, 2010 2:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
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.
Post #1027801
Posted Tuesday, November 30, 2010 2:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 30, 2014 8:52 AM
Points: 1,618, Visits: 20,966
Please go through this site. It answers all the above questions.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1027814
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse