Skip to content

SQL Server - Bad Performance

Featured Replies

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

 

 

  • Author

Ok,, How will I troubleshooting with that information?

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?

  • Author

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

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.

  • Author

Thanks for your support, that issue is now closed..

  • 4 months later...

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...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.