Hi everyone, using SQL Activity Monitor I noticed that there are multiple connections (around 200) to the ReportServer database made by the account with which reporting services service is running. However as far as I can see most of them are idle nothing is actually executed against the database and in the column Activity Monitor ->Process column Memory Usage (KB) the value is 16KB for each connection. WHat is the default idle time before a connection to the ReportServer database is closed and how can I change it? Thanks in advance

If the connections are idle, then they aren't consuming any CPU cycles. The only thing that they would be consuming is a very tiny amount of memory on the database server. They would probably be consuming a bit of memory on their client machine if they have the result set displayed, but that would not impact the database server Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance