Time out error - sql server
Posted on 2010-01-06
when i am generating report, i am getting time out error. but some time the report was generating properly (it will take time coz heavy data). but this time i am getting time out error. it is not one report, more reports giving time out error. Here i am giving one procedure details:
1. in that procedure no physical tables that is almost temp tables (i have created index on that table).
please find the database & server configuration details:
Total RAM : 32 GB
MIn server memory: 4096 MB
Max server memory:26622 MB
min memory per query:1024 KB
cost threshold for parrelism: 5
max degree of parrelism:0
max worker thread:567
number of users: 5
data files: (1 P F, 12 NDF files).
data file size : currently allocated space (249764.81 MB)
availble free spcae (22689.56 MB (9%))
currently allocated space (18055.75 MB)
availble free spcae (18018.87 MB (99%))
currently allocated space (0.50 MB)
availble free spcae (-23.37 MB (-4674%))
please let me know what could be the reson.