Windows RDP - Remote session cache free

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Windows RDP - Remote session cache free

Author

Topic

sridards
Starting Member

6 Posts

Posted - 2010-11-03 : 01:25:06

Hi,

I have application with back end of Sqlserver. After opening one of the screens in the application, it utilises 250000kb of memory usage (while checking through task manager - processes).

I am working as one Terminal session by logging in to Terminal server with windows 2003.

So in this situation the application process is utilising 250000kb of memory. fortunately i needed to disconnect my session since i have to work on my local system for some other purpose and then i have connected to the same terminal session which was disconnected. when i see the memory usage of my application which was running is utilising only 8000kb and still i can work on the application and even when i close the particular screen and open again it utilises only 8000kb instead of 250000kb. I was surprised to see this. So something can be done to reduce the application's memory usage by calling some API Calls in windows or some commands can be passed in SQL Server i believe.

Can any one knows about this kind of situation? can any body suggest me a solution to force the windows to reduce the application's memory usage?

Please suggest me as early as possible.

Thanks
S.Sridhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-03 : 08:58:57

Is "lock pages in memory" granted for your account? If no, then that's a problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sridards
Starting Member

6 Posts

Posted - 2010-11-08 : 00:26:24

Hi,

Thanks

Where can i find 'lock pages in memory' configuration? somewhere in windows or in Sql server? Kindly reply

Thanks
S.Sridhar

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-08 : 01:17:17

quote:
Originally posted by sridards

Hi,

Thanks

Where can i find 'lock pages in memory' configuration? somewhere in windows or in Sql server? Kindly reply

Thanks
S.Sridhar

Have a look at:
http://sqlserverpedia.com/blog/sql-server-bloggers/lock-pages-in-memory/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources