-
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.
-
Reply for performance
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|