sql server become slow

Question

hi

:(

what happen that sql server 2008 become very slow Already sql server was fast

Answer 1

Hi,

Can you think of anything which may have changed before SQL Server 2008 became slow?

http://support.microsoft.com/kb/298475

http://www.mssqltips.com/sqlservertutorial/276/sql-server-performance-tuning-and-monitoring/

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood

Answer 2

The complexity of the performance  is not specific to a particular database object or operating system. All applications are subject to performance constraints because of resource, design, or usage factors as use of the application increases and the size of your database increases we may notice some performance issues that its not like earlier 

for continuous monitoring of our SQL performance u can follow given link 

http://tinyurl.com/8twg8gx