Encerrado

We need a DBA with SAAS experience

We are a CRM SAAS Provider. For some reason each morning between 8h00 & 9h30 am SA (Harare) time our system crawls almost to a halt.

According to the SQL logs the tempdb file is cleared and there is a restart. Straight after the restart for the rest of the day the system performs very well.

We are on SQL 2008 R2 which is hosted at a secure third party data centre.

There are 820 users on the system - not all at the same time.

How do we prevent this reoccurring. The problem is critical.

Habilidades: SQL

Ver mais: dba, crm saas, crm sql, saas crm, sql crm, dba sql, need someone organize data, need 70s party flier, need experience sql

Acerca do Empregador:
( 0 comentários ) South Africa

ID do Projeto: #5131634

9 freelancers estão ofertando em média $379 para este trabalho

finecodervw

Hi, What is the nature of queries fired by the users. Are these queries scheduled or ad-hoc queries. Are any of these really heavy. Would like to discuss more on this with you. Let me introduce myself as an datab Mais

$200 USD in 10 dias
(13 Comentários)
4.8
angan

A proposal has not yet been provided

$222 USD in 3 dias
(16 Comentários)
4.2
elboukharimu

Hi, I'm very interested helping you resolving your database problems, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is so Mais

$242 USD in 5 dias
(8 Comentários)
4.0
Prateekagra

hi i have a sound knowledge of development and have 7 years of experience tell me when we can discuss the same

$222 USD in 10 dias
(5 Comentários)
4.0
webdevit

php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysql team,php/mysq Mais

$309 USD in 3 dias
(0 Comentários)
0.0
xcorporation

Would need to see the sql logs - probably 15 minutes. any given timeframe is fine fine. If it's not in the logs - it's processing like sql server reports or user activity. One way or another - i can opimize that Mais

$144 USD in 3 dias
(0 Comentários)
0.0
mrazasaeed

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)
0.0
freedevs

Hey There ! I am interested to work on this project. Please pm, for further clarification. Please refer to my profile to gaze my capability. Thanks.

$1666 USD in 15 dias
(0 Comentários)
0.0
srinichal

I am willing to discuss further about the project specifications and needs to deliver the same .

$252 USD in 12 dias
(1 Comentário)
0.0