Sokoban Posted June 30, 2016 Report post Posted June 30, 2016 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 Quote Share this post Link to post Share on other sites More sharing options...
0 GarthMJ Posted July 1, 2016 Report post Posted July 1, 2016 Based solely on what little data you can given. Upgrade you disk to faster disks. Quote Share this post Link to post Share on other sites More sharing options...
0 Sokoban Posted July 5, 2016 Report post Posted July 5, 2016 Ok,, How will I troubleshooting with that information? Quote Share this post Link to post Share on other sites More sharing options...
0 GarthMJ Posted July 6, 2016 Report post Posted July 6, 2016 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? Quote Share this post Link to post Share on other sites More sharing options...
0 Sokoban Posted July 7, 2016 Report post Posted July 7, 2016 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 Quote Share this post Link to post Share on other sites More sharing options...
0 GarthMJ Posted July 7, 2016 Report post Posted July 7, 2016 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. Quote Share this post Link to post Share on other sites More sharing options...
0 Sokoban Posted July 8, 2016 Report post Posted July 8, 2016 Thanks for your support, that issue is now closed.. Quote Share this post Link to post Share on other sites More sharing options...
0 michaelwarne Posted November 11, 2016 Report post Posted November 11, 2016 Great Job Keep it up. Quote Share this post Link to post Share on other sites More sharing options...
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