HI,

I even checked the event viewer, nothing found. We are expecting because of Antivirus update on Production server, the issue occurred...

Thanks

Praneeth

HI All,

SOrry for the trouble...

I argued with my colleague and replace the memory setting to Max.

I explained and convinced them. Now its all good....

Thanks for the advices....

Now they want...

No Reboot. Today surprisingly my manager asked another DBA to check and he reduced the memory CAP to 10 GB, and no issues till now.... I am very eagerly waiting...

HI,

I dint run cleanbuffer..

HI,

My Page life Expectancy value is 80..

is there any memory leakage....

Hi Newbie,

We are doing statistics updates on regular basis and Affinity is taken care by SQL server internally i guess.

when I execute sysprocess it is showing all the running id's...

HI All,

After a long time.

Now my Database server physical memory reached to 90%...

Client is sitting next to me and asking for reasons...

I tried all the possible ways to see what...

HI,

Its going high from 52% to 65,70,72 & today 80%...

tomorrow it may reach 90 & finally 100%...

HI All,

Today my physical memory reached to 80% in my database server.

Please suggest what to do to reduce it now...

Thanks

Praneeth

What is the best practice or recommended settings to configure sql memory..

like max memory setting

Thanks a lot ..

Regards,

Praveen

Thanks a lot andrew gothard & Gail,,

For your perfect solution.

I would like to know more about the memory architecture of SQL Server. If you have any link or docs, can...

Gail,

Client is asking to reduce the memory utilisation for DB server...

Thanks

Praveen

HI,

Without any activities in the sql server, it is consuming a lot.

I want to know on what basis/activities are going internally...

If users connect then memory utilisation will raise beyond this,...

Hi,

My biggest concern is that the number of users are very less 7 members and as of now no OLTP.

No other softwares were installed, it is dedicated to sql server...