Results 1 to 3 of 3

Thread: My Database performance is very slow

  1. #1
    Join Date
    Jun 2007
    Posts
    2

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

  3. #3
    Join Date
    Jun 2007
    Posts
    3

    Smile 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
  •