For some reason one of our SQL Server databases seems to exhibit a performance issue where the various application components start timing out. We can go for several weeks with no problem, then for several days in a row the timeouts start to occur typically in the early afternoon and last until around 8:00pm.
We need a MS SQL Server expert to investigate this and tell us what is causing the problem
25 freelances font une offre moyenne de 38 $/heure pour ce travail
Hello, As an expert in ms sql server, i am very much interested to work to find out the reasons and improve the performance of your sql server. Looking forward to have a positive response from you. Thanks
I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I am familiar with SQL audit tools and methods.
I have over 20 years work experience in Oracle and SQL Server databases as DBA. I have worked with Oracle Corp and have taken training on Oracle internals. I have managed production environment for a hedge fund.
first step checking the bandwidth for both read and write(finding the logical reads and physical reads) second step check for indexes rest processor usage, statement usage, waits
Project: SQL Server Performance Check Skills: VB, VB.NET, ASP.NET, MSSQL Experience: 11 Years Expertise: Desktop and webapp development Team Size: Dedicated Programmers