Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
griffo138
Starting Member
1 Post |
 Posted - 2010-12-06 : 07:12:58
|
| Hello,I work for a hosting company and we're seeing an increasing number of timeouts from IIS and SSMS. SSMS is only when you connect remotely and usually when you use design view. The real problem is IIS. There are about 100 websites with connections to MSSQL databases, the db's are all small, under 50mb. there are a maximum of 120 db's. Timeouts only happen on the 'first hit' i.e after the app pool has been recycled. But they didn't do this a few months ago.The timeout generally comes back very quickly, from what I know the default timeouts are around 30 seconds for most connections and it's much quicker than that.Any suggestions?Regards,Andrew |
|
|
dbird
Starting Member
4 Posts |
Posted - 2010-12-07 : 10:57:56
|
| Try using the server full name with domain information or IP address. If that works add the name/IP address to the HOSTS file on the remote client |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-07 : 11:04:04
|
| Long shot: Databases not set to AUTO CLOSE are they? |
|
|
|
|
|
|
IIS/SSMS Timeouts