3/6/2015 4:01 PM | |
Joined: 2/11/2015 Last visit: 7/12/2024 Posts: 51 Rating: (1) |
Thanks for your help. Joined servers load, tagloggingfast archive config (tagloggingslow is the same) and alarm logging archive config. I remark that my 2 archive configurations are different. I'd like to have alarms and trends for the last month. Wich config is the best? Servers are 64-bits. Is it a way to know the memory used by SQL corresponding to alarm/tag logging? Thanks AttachmentServers load.zip (94 Downloads) |
3/20/2015 8:26 AM | |
Joined: 2/11/2015 Last visit: 7/12/2024 Posts: 51 Rating: (1) |
We made some tests and remarqued this: - used RAM before opening alarm logging: 1.2Gb - used RAM after opening alarm logging: 2.1Gb - used RAM after closing alarm logging: 2.1Gb We tried to find a memory optimiser that can be found here: http://www.wisecleaner.com/wise-memory-optimizer.html for example (free and portable). When we 've run this, the used RAM get down from 3.6 to 1.8Gb with no impact seen on alarm and archive. The commited memory to SQL Server goes from 1.4Gb to 0.4Gb. Is the memory well managed by the SQL Server? |
Follow us on