hi to all, i am new to this forum, can anybody please tell me what is performance tuning and how to check the performance of sql server 2000 when an application retrieving huge records from database.
Looking at your thread, it seems you are new to this forum as well as SQL server. Performance tuning is an advanced subject as tuning needs to be done to queries or tuning to server. Read more articles on the net, in books and Books online supplied with product could be very handy in all cases
Here are a couple of links you might consider to get you started in understanding performance tuning for SQL Server 2005: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032256511&Culture=en-US http://msevents.microsoft.com/CUI/W...&EventCategory=3&culture=en-US&CountryCode=US
Hi Greg, I think is SQL 2000 not 2005. About original post: Take a look of our articles, you will find a lot about tuning 2000.
Typo on my part. Sorry, but the links are to SQL Server 2000, not 2005. So they might still be of some value.
