Optimise a Windows Server with MS SQL large database site

Hi I need someone that knows how to optimise a dedicated server for running a large MS SQL database driven site, basically iam a developer but am not very knowledgeable when it comes to application pools and how to best optimise services on the server.

The website does not need to handle thousands of visitors at once its more a case of probably 30-40 at any one time but it has a very detailed search facility that uses a MS SQL database with over 30 million records so this is why i need to optimise, as each search i think does use alot of resources but only for small amount of time.

Its running on a virtual server so i can easily up processing and memory but I want some expertise before i go ahead and just add more hardware power.


Skills: SQL, Windows Server

See more: windows virtual server, virtual server windows, power up case, need a hardware developer, hardware resources, case power up, virtual server, optimise website, MS SQL, server case, website virtual server, virtual memory, sql small database, windows power, memory database, dedicated virtual memory, database driven application, hardware windows, Server hardware, SQL Database Developer, need million visitors, sql analysis windows server 2008, hardware power, virtual dedicated server, sql server services

About the Employer:
( 0 reviews ) St Leonards on Sea, United Kingdom

Project ID: #5371394

17 freelancers are bidding on average £208 for this job


Hi, Virtualization,Hyper-V, Windows 2008,12,DNS,Exchange AD,IIS expert here. We can discuss further. Thanks

£277 GBP in 10 days
(22 Reviews)

Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have ex More

£222 GBP in 3 days
(15 Reviews)

Optimizing a Database heavily relies on queries running and database scheme. USUALLY the weakest point is IO performance, so this is something you should definitely look into. Get back to me to talk about it

£200 GBP in 3 days
(27 Reviews)

I want to see the issues...................................................................................................................................

£257 GBP in 3 days
(6 Reviews)

Aucune proposition n'a encore été fournie.

£200 GBP in 5 days
(16 Reviews)

I have understood the problem. I can solve the issue by applying good concept. After that your database will work smoothly. You don't need to worry for that. you can check my profile to know more about me. Waiting for More

£277 GBP in 3 days
(13 Reviews)

A proposal has not yet been provided

£150 GBP in 3 days
(7 Reviews)

Hello, BenUK44! I am ready to optimize it for you. Install your SQL Server on separate server would be better decision - because you can format your raid massive with 64k claster size format (because MS SQL use 8K page More

£150 GBP in 3 days
(5 Reviews)

I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / ) ,PHP, WordPress, SharePoint, VBA, C, C++ a More

£111 GBP in 5 days
(3 Reviews)

Hi, Choose my bid. I can do [url removed, login to view], Choose my bid. I can do [url removed, login to view], Choose my bid. I can do [url removed, login to view], Choose my bid. I can do it.

£277 GBP in 3 days
(1 Review)

Hello, Interested by your project i would like to inform you that i am IT engineer , having more than 7 years in IT projects with 5 years in database development and administration in SQL Server and i have worked More

£188 GBP in 5 days
(1 Review)

Hello, Major factor in database performance is indexing. Ik can look at your database and make a check on indexes. It would be helpfull if I can see a realistic (SQL)workload and make my advise on that. Memory i More

£222 GBP in 3 days
(0 Reviews)

Hello, Which SQL Server version and release is, and over which Windows Server version/release? Which tool do I have to use to remotely connect to the server? MsTsc? If you doubt about my expertise about SQL Serv More

£211 GBP in 4 days
(0 Reviews)

Hello. I have over 12 years’ experience in the design, development and tuning of the various databases (Oracle, MSSql, MySql, etc.). Please specify what's on your primary task: setting parameters for stable opera More

£100 GBP in 3 days
(0 Reviews)

My initial actions will be to look at DBMS performance tuning before even looking at the database. The DBMS (in this case SQL Server) needs to be running to its fullest potential before examining the database. This wo More

£222 GBP in 3 days
(0 Reviews)

A proposal has not yet been provided

£250 GBP in 3 days
(0 Reviews)

Hi Ben, I would love to help you with this project. I've been working with Windows Servers and MS SQL for almost 15 years, and have a great deal of experience with these kind of setups. My latest project is a fu More

£222 GBP in 3 days
(0 Reviews)