Jump to content




Sokoban

SQL Server - Bad Performance



Recommended Posts

Hi

 

I have SQL Server problem in the office,

SQL Servers have very high traffic (many transactions) It's filled the disk on the server, and same the database slower.

 

How will I solved that ?

 

Sokoban

 

 

Share this post


Link to post
Share on other sites


Based solely on what little data you can given. Upgrade you disk to faster disks.

Share this post


Link to post
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×