I am facing a performance problem on our server. The main reason seems the versions of OS and SQL Server. Once I install the SQL Server 2008 on Windows Server 2008 R2, the response time of my web site becomes very slow. Whereas, if I use SQL Server 2008 on another machine which has Windows Storage Server 2003 R2, the response time is much faster.
Both operating systems have the latest updates, do you have any idea of this contradiction? or did anyone experiencing similar problem about new updates to Windows Server 2008 R2 which is running SQL Server 2008?