Speed up a very slow database

$250-750 AUD

Closed

Posted

over 8 years ago

$250-750 AUD

Paid on delivery

Since this database was separated from a MS Windows SBS 2003 environment to change physical locations, it has run exceptionally slowly. It is running on and old SQL server with MS Access front end. I don't want anything fancy, maybe just simplify or remove the security features (probably doesn't need Windows NT authentication) and speed it up so that it's doesn't take 20 seconds for each screen to come up.

Microsoft Access

Microsoft SQL Server

Windows Server

Project ID: 8474868

About the project

7 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

7 freelancers are bidding on average $575 AUD for this job

@benji0522

A proposal has not yet been provided

$499 AUD in 10 days

5.0

(64 reviews)

6.4

@fuentro

A proposal has not yet been provided

$638 AUD in 10 days

4.7

(27 reviews)

5.9

@sopholos

I have a lot of experience developing databases on SQL Server. Also I was worked as DBA, so I could help you with your problem. Actually there is no overhead from NT-auth, I think your problem persists in queries from Acces backend. Probably there is full-table reading instead of filtering queries. Also your backend may block tables with long-transactions. I need estimate your queries on SQL Server to find issue. After I will find issue I will propose you next steps and do some step for myself. For example I can create missed indexes and rebuild some view/stored procedures if any. Damn freelancer again broke milestones feature. So I will put it here: 1. Find issue. I will use SQL Profiler and internal monitoring features. 2. Write down issues with some steps to fix 3. (re)build missing indexes and rebuild view/stored procudres

$1,473 AUD in 7 days

4.9

(9 reviews)

4.5

@ifaisal

hello i can do this for you. i have plenty of experience in database and ms access. please see my feedbacks. i would need ms access application and database copy.

$277 AUD in 2 days

5.0

(5 reviews)

3.4

@mmuthamilselvan

I have over 10 years of experience handling different databases. I can help you optimize your application. Please let me know further. Regards, Selvan

$280 AUD in 7 days