June 28, 2002 at 11:17 am
Hello all,
I have about half a Gig of memory on one of my boxes. There is one user connected and is doing a update on a table with just over 5 million rows and the update will affect only about 20,000 rows. However, the Windows Task Manager is showing that SQL Server is using over 450MB of memory. I do not see any other transactions in the Current Activity window. Any ideas? Thanks in advance.
June 28, 2002 at 11:27 am
SQL will take all the memory it thinks it needs to complete a query. If this is a large query, SQL may be caching the data to speed the update.
I wouldn't be concerned unless this affects performance. 512MB of mem isn't a lot and SQL could easily take 450 to optimize itself. By itself, this is not a big deal.
Steve Jones
June 28, 2002 at 12:23 pm
How can I check the memory page size?
June 28, 2002 at 12:51 pm
What do you mean? The page size for memory is set with NT.
Do you mean the number of pages in memory? Not sure about that one.
Steve Jones
June 28, 2002 at 1:03 pm
I want to know what is the page size of the memory pages. I look in the Enterprise Manager/Current Info/Process Info and the Memory Usage Column shows very little memory pages being used. But on one of my servers SQL Server is using over 1.7 GB of memory. I just want to know how to check the memory page size so that I can add up the pages being used to see if it adds up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply