I am running a daily batch job to update a sizable amount of data. I have been testing this on my development machine and the job takes about 2 hours. I have migrated this to my production virtual server and the job now takes 12hrs.
I believe that the SQL servers are set up the same – but I am happy to check specific if they are pointed out.
All data is stored locally relative to the running job (either on the server or the PC)
The Development PC is used only for development. The Virtual server hosts the website application that uses this data. as the job runs this has a crippling impact on the website to make it unusable. Viewing Task manager on the server as the job is running the CPU hovers around 20% and the RAM at 2.5GB of the available 4GB. I currently have very little traffic to the website and do not want to encourage traffic till this is resolved.
Specs are Development
Windows 7 Professional version 6.1.76
x64 based PC 2.93Duo CPU
MS SQL Server 2008 Express 10.0.25
Windows Web server 2008 R2 ver. 6.1.76
2 x quad core AMD 2.29 GHz processors
MS SQL Server 2008 Express 10.0.1
Any suggestions on why there is a difference and how to resolve this would really be much appreciated. This is preventing my web site from running effectively for 10hrs a day as the job runs.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers.
Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job.
The first step is to acquire the necessary licen…