Hello all ,
I have a client / server database application .
Sometimes when I am running reports ( dw ) , after about a minute I get an error message says something like:
can not complete operation due the time elapsed ….
and sometimes its works great . I can't determine any rule .
Running the same sql under Mssql studio management works great .
I am using Ado.Net for connecting .
Application is pb 2017 R3 .
OS : window server 2012 R2.
DB : Mssql 2014
The db file is about 2 GB and the log is 13 GB.
I have checked indexes and rebuild all again and again .
remark : Running the same reports with Sybase sqlanywhere 11 , I have never saw a message like that ( with smaller db files , but still never something like that )
Any ideas ? Are there any parm I should include in the connection string ?