shrink sql server database and reduce memory usage today

We are having problems in the last few days with our VPS server using a lot of memory. It is using [url removed, login to view] - [url removed, login to view] and sql server is using 800 - 900 MBs of that and [url removed, login to view] is using 100MBs. The backup of the entire sql server express database is [url removed, login to view] but there is only one database within it that is very large at 920MBs.

I deleted 220,000 records from one of the tables yesterday and attempted to shrink the database but I'm not sure if it worked. It gave an error first time and then each other time I tried the window would appear for a second and then close. It didn't make any difference to the size of the backups and the memory usage is still the same so it mustn't have worked. We are getting a lot more '1.1 new session failed' messages since yesterday and when I restart the sql server memory reduces down to 960MBs and then once restarted returns to [url removed, login to view] within 15 mins.

About 3 months ago I deleted a load of records and shrank the database and it has worked fine ever since until yesterday. Can somebody who specialises in this sort of thing give us an hour or two of your time to help sort it out please?

Kemahiran: Microsoft, SQL, Sistem Admin, Destop Windows

Lihat lagi: reduce sql server memory usage, shrink sql server memory, shrink sql memory, shrink sql server memory usage, sql shrink memory, reduce sql server memory, reduce memory usage sql server, shrink database sql server, reduce memory sql server, shrink database sql server memory, sql reduce memory usage, sql server reduce memory usage, shrink sql server usage, one hour ago, hour ago, sql memory usage reduce, sql server memory usage shrink, can shrink sql memory, sql server memory usage reduce, sql server memory reduce

Tentang Majikan:
( 102 ulasan ) Dublin, Ireland

ID Projek: #598736