Jump to content


Sokoban

SQL Server - Bad Performance

Recommended Posts

Ok,, How will I troubleshooting with that information?

You haven't giving us anything to work with.

 

What have you done to troubleshot this?

Why do you say your server is slow?

Have you review the application to see why it is filling up the disks?

Is you SQL server sized right? Are you sure?

Is the server a VM? Do you have dedicated physical disk for it?

Have you looked at Prefmon?

Share this post


Link to post
Share on other sites

thanks, it was troubleshooting processes I am looking for .. Something I have missed ?

 

  • Monitorera traffic to see what causes this, there are programs that SQLRecon or Prefmon.
  • Refer to the SQL Server log files, to see if something is there.
  • Upgrade to faster disks.
  • Separate the Data and Log Files, add judgment on different disks to reduce traffic. Minimize tempdb file, ensure that tempdb files have the same size and is located on a separate disk.
  • See why the Application Fill up the disk.
  • If the VMware Server, use physical disks.
  • Change the Max Memory Limit, this is done in the SQL Management Studio.
  • How are the performance on the server update on the hardware?
  • Perhaps we need an update of SQL Server ?

 

Sokoban

Share this post


Link to post
Share on other sites

thanks, it was troubleshooting processes I am looking for .. Something I have missed ?

 

  • Monitorera traffic to see what causes this, there are programs that SQLRecon or Prefmon.
  • Refer to the SQL Server log files, to see if something is there.
  • Upgrade to faster disks.
  • Separate the Data and Log Files, add judgment on different disks to reduce traffic. Minimize tempdb file, ensure that tempdb files have the same size and is located on a separate disk.
  • See why the Application Fill up the disk.
  • If the VMware Server, use physical disks.
  • Change the Max Memory Limit, this is done in the SQL Management Studio.
  • How are the performance on the server update on the hardware?
  • Perhaps we need an update of SQL Server ?

 

Sokoban

 

If you have done these things, Then it is time to call in a expert on SQL and your application to troubleshot things. There is nothing more that someone within the forums can do to help you.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...