My Database performance is very slow

Hi Exports,

My database performance is very slow how increase the my database performance.
what are step we have follow to increase the performance
plz guide MS SQL SERVER 2000

Thanks
shiv

Your question is too vague, performance can be slow because a number of things, you need to find out what is slow.

Is server CPU 100% utilized, is there paging, is memory too low, is one query causing the performance problem, etc.

Hello

As per my knowledge if performance is low of computer then it's depends on computer architecture. may be unsufficient memory size.

if it is problem with Database and Data is not retriving fastly then Database partition is one of the solution another solution is rownum

if you are using SQL Server then top and any other function may work for it.

but if your system is low then check your pagefile.sys and remove some unneccesary software from the system.

if i am wrong then inform me.

Thanks

Regards
Harsh