I have a Microsoft ASP.NET MVC web application with SQL Server 2008. Currently running on a single server, performance is reasonable. However I now need to deploy the same application to support much higher volumes. There are also a number of high-load services (for real-time route scheduling and processing of data feeds). I believe that I will need a separate database server and one or two web-servers. If I host at somewhere like 1&1 or [...]

This is my first attempt at virtualizing SQL server on VMWare and I want to make sure I am doing things correctly. Should I have SQL server installed on the C: drive / same partition as the OS, Then add a virtual disk for the Data files, say 300GB, and then another virtual disk for the log files say 100GB? Or should I add 2 300GB vdisks, for the data files mirror them in the [...]

I have just been given access to a new Windows Web Server 2008 R2 which has SQL Server 2008 R2 installed on it. When I open up SQL Server Management Studio and try to connect, it does so with Windows Authentication, however, it does not ask me for a password, and it successfully connects. I am worried that (hopefully not) someone who shouldn’t be accessing the server does so, and can then easily connect to [...]

Possible Duplicate: How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment We have an ASP.NET Web API server that serves up a SQL Server data driven website. The API uses JSON to transfer data from SQL Server to the front end. We need to move it to an internal production environment (nothing will be exposed on the public Internet) and we’re having problems – or just not understanding what needs [...]

I am collecting PerfMon counters on a SQL Server 2008 server (which is hosted on a VM), and I am getting different Page File % Usage values for _Total and C:\pagefile.sys. The C:\pagefile.sys values are consistently at zero, and the _Total values are consistently around 26. Other counters (Memory Grants Pending, Page Life Expectancy, Processor Queue Length, Available MBytes) all are showing values indicative of memory and cpu pressure, so I would think that there [...]

we have a medium sized SQL db of around 40GB, and are about to move it to a new box with server 2008 r2 x64 some expensive contractor blokey has just come in and said we need 72gb of ram so that the whole DB can live in RAM i guess.. , I find that ludicrous, but maybe its me being a wally.. wonder if there is a ‘rule of thumb calculation’ that hints at [...]

I checked my SQL Server 2008R2 log in Log File Viewer and found out that someone from China keeps trying to login as ‘SA’ all the time, but failed of course. Is there anyway to prevent these hackers attacking my server? Thanks in advance. Asked by nonintanon Use firewalls – why on earth is that port (or any ports on an SQL server) open to the rest of the world? Most business have multiple network [...]

I have a Windows Server 2008 R2 running Microsoft SQL Server 2008 R2. I have some how lost 300 GB of disk space, and I can’t seem to find it anywhere. The Hard Drive is 500GB and I can only account for 200GB. I have “Show Hidden Files” on and “Hide Protected Files” off. I have check the details for every folder top level folder, and I still can only find 200 GB of a [...]

Is there a tool from Amazon or Microsoft to automatically upgrade an ec2 instance’s sql server 2008 to 2012? Or do I have to create a new instance and then import all the databases? Asked by Robert Louis Murphy One of the joys of EC2 is that you can create instances so easily, for the tiny cost of a few hours of runtime. I’ve had so many system upgrades (win/mac/unix) go wrong that I would [...]

I have a big problem with the SQL Server Agent hostory. it has become VERY VERY slow when i try to view it. If I try through Management Studio I often get a timeout and if I try viewing it with sp_help_jobhistory it is just running for a long time. I tried reducing the hostory size and the sysjobhistory table has only 8000 rows…. Is there any way to optimize this somehow? Thx a lot [...]