Can anybody shed some light on whether I can expect any performance increases if I moved an SQL database from a shared DB server to a dedicated DB server?
I use an SQL database that's currently hosted on a machine with 400 other databases. I have no idea of the specs of that machine, but I would have thought they would be quite high.
Currently, the response time to queries seems to get slower and slower as the day progresses, and I'm trying to determine if I would see a performance increase if I had my own DB server machine.
I imagine that the database queries take longer to execute as the day progresses as the websites accessing the DB's on the server are getting busier, so the server has more work to do.
I know there are about 400 DB's on the current machine, but I have no idea of how the memory allocation on that server works. If the machine has 16gig's of ram for example, is each database allocated a percentage of that RAM that it can use, or does each database have the ability to use as much RAM it needs, or is there an upper limit on the amount of RAM a single database can use at one time, or are these kind of configurations all specific to how the admin has set the machine up?
The server I was looking at renting has twin 2.4 Xeons, 2G ram, RAID 5 disks etc.
If I was to have this server and put just my own single SQL database on it and nothing else (no websites etc), I assume that my database would have nearly the whole 2 gigs of Ram at it's disposal all the time.
In which case, do you think my queries would execute faster than they do currently on the shared server, even though the shared server has X amount more RAM that I'd have on my own server?
I know these questions may not be answerable due to not knowing the specs of the current shared machine, but has anyone made a similar move and noticed a performance increase?
Any input or advice is very much appreciated.