SLOWSQL on OS Express and IT Asset Manager fresh install

SLOWSQL on OS Express and IT Asset Manager fresh install

  
Hi,

After a fresh install of Outsystems Express I found that IT Asset Manager is very slow.

On the Service Center I found several SlowSQL warnings and on the Event Viewer I found several of the following:
----
Error openning connection to the database: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Retrying...

Message generated by eSpace WidgetLibrary40.
----

No one is using this machine and the SQLServer is only used for OutSystems.
How can I further drill down this problem?

Thank you

João Campos
Before any of the previous I also find (on the event viewer) two of the following:

WMI ADAP não conseguiu criar o objecto Win32_PerfFormattedData_MSSQLOUTSYSTEMS_MSSQLOUTSYSTEMSBufferManager para a biblioteca de desempenho MSSQL$OUTSYSTEMS porque foi devolvido o erro 0x80041002


João Campos


Hi João,


Have you tried to disable the IT Asset Manager scan Timer? Did your slow sql warnings and WMI errors disappeared?


Cheers,

Rodrigo Castelo