Optimize a windows server with ms sql large database site, Web Project

Assignment Help:

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

The website does not need to manage thousands of visitors at once it's 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 optimize, as each search i think does use alot of resources but only for small amount of time.

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

Skills required are SQL, Windows Server


Related Discussions:- Optimize a windows server with ms sql large database site

Upload products to google shopping, Upload products to Google shopping P...

Upload products to Google shopping Project Description: I just buy simple Google shopping extension for magento store and I want someone to use the extension to upload my web

Gambling project, C# EXPERT NEEDED for Gambling To work on software alre...

C# EXPERT NEEDED for Gambling To work on software already prepared several years ago, and running under C#, we need an expert in this tool and domain to install it and to verify

Implementation a billing system to roku apps, Implementation a billing syst...

Implementation a billing system to roku apps Project Description: We are seeking a developer who know about amazon web services to implement a billing system using amazon s b

Game based on predicting sports outcomes, Mobile app: Game based on predict...

Mobile app: Game based on predicting sports outcomes I am looking for someone to assist me build a cool new app, where: + Users start "leagues" (as like in fantasy football)

Push to talk on intranet between two clients, Push to Talk on Intranet betw...

Push to Talk on Intranet between two Clients Project Description: I need for a project the subsequent: Two people will communicate on one (max. two) computers through a pu

I am in search of someone to help me complete website, Finish Website I ...

Finish Website I am in search of someone to help me complete some things on an existing website developed in ColdFusion. This person would want to finish uploading products onto

I need facebook and coldfusion expert, Need Facebook AND Coldfusion expert ...

Need Facebook AND Coldfusion expert a) Need to Add Facebook Comments b) Need to add Facebook Posts to Website c) Need to pull facebook fans d) Need to Facebook schedule

We need expert on jquery for mobile template creation, We are looking for a...

We are looking for a Jquery mobile expert with good css skills who has created Jquery mobile plugins and Jquery ui before and utilized other advanced java-script and CSS programmin

Prepare bitcoin raffle, Prepare Bitcoin Raffle/Lottery Website Script Pr...

Prepare Bitcoin Raffle/Lottery Website Script Project Description: I want a Bitcoin raffle and lottery script to be made. Settings allow a custom ticket price, drawing times,

Microsoft exchange 2013 dag and replication, Microsoft Exchange 2013 DAG an...

Microsoft Exchange 2013 DAG and Replication Project Description: I am seeking migrate a 2013 Microsoft Exchange environment from AWS EC2 to VMWare ESXi. There are 150 mailbox

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd