COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: vigc0 on 27 Nov 2018 05:27:29 PM

Title: Content Store on SQL Server. Memory requirements
Post by: 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
Title: Re: Content Store on SQL Server. Memory requirements
Post by: MFGF on 28 Nov 2018 02:32:53 AM
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.