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: sql dba, DBA, crm saas, crm sql, saas crm, need native italian data entry, office need util extract data dot files, need somebody scrape data site, days need time analyse data using spss, sql crm, dba sql, need someone organize data, need 70s party flier, need hire someone data website, need captcha code data entry job, housewife need freelancing programming data entry job, 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