how to find Ram memory occupied by sql server

  • GilaMonster (9/23/2011)


    Gianluca Sartori (9/23/2011)


    I always feel safer when I set up a SQL_SERVICE user on my laptop with no special permissions. Maybe I'm paranoid, but that's just how I feel. -)

    I could, but seriously what's the point?

    This is machine on a single-user network (it's not a laptop that could connect to other networks). If someone compromises my network to the point they can get access to the SQL Server, I'm in a world of hurt already and the SQL Server will be the least of my concerns.

    When I change it to a domain account it'll be for cross-machine permissions.

    Oh, I see. It's a different thing, indeed.

    With my laptop I never know what's on the other end of the cable I'm plugging and with all the mess I do in my test databases I could find myself in big trouble.

    -- Gianluca Sartori

  • vaithi.saran846 (9/25/2011)


    Hi,

    Either through front end or back end query anything is enough.. Please send to me

    Regards,

    Vaithilingam.K

    Based on Gail's suggestion, this should do:

    SELECT cntr_value

    FROM sys.dm_os_performance_counters

    WHERE counter_name = 'Total Server Memory (KB)'

    -- Gianluca Sartori

Viewing 2 posts - 16 through 16 (of 16 total)

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