0
Good day I am with a problem , users of a given system are having problems when consulting a name in the system "a simple search" I joined the bank and noticed that in sql there are several banks and one of them other than the system that users claim is consuming 97% of the total RAM of my server , it is always so no matter the time or how many people are using, I wonder if this is wrong and if there’s anything I can do follow the data
1
Open SQL Management Studio, connect to the server that occupies all memory, with an administrator user.
Right-click on the server in the Object Explorer window and select Properties.
Adjust the memory and click OK.
Thank you very much, Father, it may give some problem of slowness in the bank that is occupying a lot of memory or is it occupying this memory without need . pq atem on weekends that there is no user it gets like this
The normal SQL Server is allocate all available memory. If you decrease the values in the instruction I gave you, it will allocate less.
thank you Marcelo again
You’re welcome, @Flavioss!
Browser other questions tagged sql sql-server performance
You are not signed in. Login or sign up in order to post.
needs more information before even giving direction. The first thing I would say is to profile and identify if any query is causing the bank to consume as much memory, sometimes a seemingly innocent
ORor a null field wreaks havoc. Check first if a query is causing this, and if it is not, you can identify the processes, but I suggest starting there– Ricardo Pontual
as I would have to proceed to check the queries and see how much they are consuming , excuse the lack of information more I am developing junior and never had to control bank like this , before who did this was a dba
– Flavio Ss