I am using a clustered instance of SQL Server 2005 Standard Edition on a 2 box cluster. I have the SSRS web server instance running on the same box.
What I'm noticing is that the Report Server takes about 30-35 seconds just to load up the main page. Obviously, this is not acceptable. I need to get the speed to down to a couple seconds or less. Any suggestions would be greatly appreciated.
Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed