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

I want a xml api travel integration, I want a xml api travel integration ...

I want a xml api travel integration Project Description: 1) A complete wordpress theme for online travel booking management. 2) Some PHP pages with the same wordpress them

Need a prestashop car parts theme plus installation, Need a prestashop car ...

Need a prestashop car parts theme plus installation Hello, I am presently looking for a prestashop car parts theme with installation onto my hosting account. Need someone who

Prepare a mobile app backend architecture document, Architecture documentat...

Architecture documentation required to meet some of the subsequent requirements: 1. shows the complete architecture of the system and the data flow diagram in Fig. 2. shows t

Twitter for cad, Twitter for CAD Project Description: Twitter applica...

Twitter for CAD Project Description: Twitter application GUI using twitter4j api that manages .dwg files. Code provided in java for data retrieval from twitter using hash tag

PHP, I''m an (Security Analysis Specialist) and i must complete this assign...

I''m an (Security Analysis Specialist) and i must complete this assignment to pass the current module of my current training certification the instructor Gave me an assignment to

I want pdf xml raw extract, I want PDF XML Raw Extract Project Descripti...

I want PDF XML Raw Extract Project Description: Application to extract XML from a Dynamic PDF, no GUI just pass a 'folder' location and the program will read all PDF files in

Need vb script to do a mass change of files, Need VB script to do a mass ch...

Need VB script to do a mass change of files I want a vb script that can help me do a mass change of files. the script must do the subsequent: 1. prompt for file extension

Want vpn/ vyatta network os, I have two hosted servers on rackspace and I a...

I have two hosted servers on rackspace and I also have a Vyatta hosted server on rackspace. I want an IP sec lan to lan tunnel setup on Vyatta, I already have the client data. C

Er diagram, how to draw the er diagram of an hr management?

how to draw the er diagram of an hr management?

Develop a reservation system for beauty treatments, Drupal 7 module: Develo...

Drupal 7 module: Develop a Reservation system for beauty treatments Project Description: For an existing Drupal 7 website we want an additional module for booking different b

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