February 19, 2012 at 2:55 pm
Hi there ,
How are you doing all ?
In oracle database, when I want to see some details about memory usage I just write (For Example)
select * from v$sga;
OR
select * from v$sgastat;
My question is does any on know what the equivalent command of this in sql server 2008 ?
Thank you so much 🙂 .
February 19, 2012 at 6:34 pm
Not very familier with Oracle but try,
Dynamic Management Views should give you a lot of information. Which version of SQL are you using?
http://msdn.microsoft.com/en-us/library/ms188754.aspx
select * from sys.dm_
WRACK
CodeLake
February 19, 2012 at 9:13 pm
Sorry the command doesn't work....Thank you
February 19, 2012 at 11:55 pm
ssaleh.k (2/19/2012)
Sorry the command doesn't work....Thank you
It doesn't work because you have to complete the command with the DMV you are interested in. Read the link that WRACK provided you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 20, 2012 at 4:43 pm
This command provides quite a bit of info on memory:
DBCC MEMORYSTATUS
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply