Home / user-56890

Filip's questions

Martin Hope
Filip
Asked: 2012-09-05 04:30:12 +0800 CST
  • 2

I've been having some performance problmes lately with my ecommerce package (ASP.net + SQL Server) running on Hyper-V based VPS so I am thinking about switching my VPS for a faster one.

To evaluate a VPS before migration I need a simple (preferably free or inexpensive) benchmark that would test come CPU/mem/disk performance and could be run on windows (VPS).

A nice-to-have feature would be ability to take into account server load. In essence I am looking for something that can take into account that server CPU is on average 80% loaded and take that into account when producing a score.

I hope I am making sense :-). Thanks!

windows-server-2008
Martin Hope
Filip
Asked: 2012-08-31 01:29:06 +0800 CST
  • 4

I have SQL Server 2008 Express running on Hyper-V based virtual machine with two vCPU-s. I've just been reading up on SQL Server 2012 Express and noticed that it's CPU is "Limited to lesser of 1 Socket or 4 cores" (http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx)

My question is how do the SQL Server 2012 limits on CPUs/Cores translate into vCPU-s? Are they "processors" or are they "cores"?

EDIT:

I've just found this: Are vCPU the same as 1 Socket, or a single Core?

Basically the solution is download CPU-Z and check, which I did. On my 2 x vCPU VPS the CPUZ is showing 1 core 2 thread so it sounds like my SQL Express should fly on both vCPUs. However when I go into processor affinity configuration it shows 2 processors there making it appear that it is using just one of the vCPUs allocated to my VPS. I am utterly confused :/

hyper-v
Martin Hope
Filip
Asked: 2011-02-05 10:10:19 +0800 CST
  • 1

I've developed a DNN5 site for customer locally on my laptop and I am having problem moving it to a production server. Server is running Windows 2008 R2 (IIS 7.5). I've copied all the files, copied db, modified web.config to see the new db, checked to make sure dnn can see the db via connection string, made sure the directory permissions are correct (appdomain user has RW access to whole virtual directory) .. and it's failing me with following error message taken out of the portals/_default/logs directory:

<log LogGUID="a3f8aab9-36b6-4d95-a605-53b4b0b02c34" LogFileID="" LogTypeKey="APPLICATION_SHUTTING_DOWN" LogUserID="-1" LogUserName="" LogPortalID="-1" LogPortalName="" LogCreateDate="2/4/2011 11:52:57 AM" LogCreateDateNum="0" BypassBuffering="True" LogServerName="SERVER01" LogConfigID="">
    <LogProperties>
        <LogProperty>
            <PropertyName>Shutdown Details</PropertyName>
            <PropertyValue>The AppDomain shut down because of a change to the application level configuration.</PropertyValue>
        </LogProperty>
    </LogProperties>
</log>

I've been stuck on this for the last 3h .. so any hint's or advice is very appreciated.

Thanks!

Filip

asp.net iis-7.5 dotnetnuke