Post reply

sql server.exe

  • April 29, 2010 at 1:22 am

    #138723

    as iam in confusion of how to rectify when we get sqlserver.exe is utilising more meomory , can any one explain of how to check when this type of request came and what factors to be consider to solve this .

    thanks

  • April 29, 2010 at 6:17 am

    #1159595

    Rectify it? Why? Is it actually causing you a problem?

    If so, please describe the problems it's causing. If you're just concerned because you've seen it increase memory utilization and you don't know what that means, then there's probably nothing to rectify.

    However, it's always a good idea to see what SQL Server Service (sqlserver.exe) is doing. The server properties window will tell you about your CPU and memory setup. Running PerfMon and a server-side Profiler trace will give you other data on what queries are running and how it's affecting Windows performance in general.

    Unfortunately, without further details on the actual problem, this is the best information I can give you for now.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • April 29, 2010 at 6:21 am

    #1159596

    This is only an issue if SQL Server is sharing that system with other applications. If it is, you're probably going to hit issues because, to put it mildly, SQL Server is greedy when it comes to memory.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

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