If you are unable to create a new account, please email support@bspsoftware.com

 

Content Store on SQL Server. Memory requirements

Started by vigc0, 27 Nov 2018 05:27:29 PM

Previous topic - Next topic

vigc0

We are using a SQL server instance for hosting the Cognos analytics Content Store. 

Yesterday we started experiencing some memory problems with Queries made on the content store.  Those queries are related to cognos security management and they all ended up failing with "waiting semaphore" status.

It seems that our server hosting this SQL server instance does not have enough memory to run the request. 

After looking around for guidelines regarding memory requirements for content store hosted on a SQL server instance, I found nothing.

Could somebody tell me where I could find such information?

Thanks

MFGF

Quote from: vigc0 on 27 Nov 2018 05:27:29 PM
We are using a SQL server instance for hosting the Cognos analytics Content Store. 

Yesterday we started experiencing some memory problems with Queries made on the content store.  Those queries are related to cognos security management and they all ended up failing with "waiting semaphore" status.

It seems that our server hosting this SQL server instance does not have enough memory to run the request. 

After looking around for guidelines regarding memory requirements for content store hosted on a SQL server instance, I found nothing.

Could somebody tell me where I could find such information?

Thanks

Hi,

This would be a database server sizing exercise. You know the size of your database, and you can also get a good feel for the number of concurrent requests being made to it. I googled SQL Server memory sizing, and the below link came up as a hit:

https://blog.heroix.com/blog/how-much-memory-does-microsofts-sql-server-need

Good luck!

MF.
Meep!