Here is my information about SQL server and window platform .
Microsoft SQL Server 2005 - 9.00.3228.00 (X64)
Feb 9 2008 09:33:32
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I have been here only 2 months ,and I have not much more details about their database .I am looking there are some performance issues daily such as high CPU spikes ,Greater disk queue lenght ,high pages expectancy etc .so I need to know anyone can give
me step by step infromation to look at new Database perfomance and how to analyse the problem and whats necessary steps do I need to improve my company database perfomance ?I dont know from where I will start to look in Database ?
Please give me some steps by steps detail infromation ,so I will start to look at my database and find out whats causing sometimes high CPU spikes ,highter disk queue leght ,high pages expectancy .How can I find which query are running long ,and causing
high CPU spike ?How can I check in which table I need to add or remove indexes to improve perfomance ?
View Complete Post