Dear All
We are using Windows Server R2 (SP1 64-bit with 4GB). Using SQL Server Express, we have 9 databases (IIs {version 6.1} using ASP - thus 32 bit) which we have been backing up daily using the "BACK UP" SQL command for years. The set up used to run
with no problems for the last 4-5 years. Since this morning the SQL server has been experiencing performance issues (meaning, screens which used to take 2-3 seconds to display take 10 or 13sec, screens that would take 5-6 sec take as much as 23 sec). The databases
range from 100MB to 8MB (same structure less content).
We have copied the various database backs ups, and loaded it in Windows 7 (64 bit, 8GB i7) and we get the same performance. We have loaded it also on a back up server, and we got the same performance as well (eliminating hardware, or excessive user load).
Can anyone shed any light whether MS update on the 12-Nov broke anything in an environment such as ours? The server is bright an ...
Go to the complete details ...