Hi all,
My question includes all 32 bit apps, but what prompted the question was a lot of hourglass time with MS Access 2003 when running on the 64 bit server. Is there some sort of 'emulation mode' or thunking that goes on when any 32 bit app runs on this server?
The server in question is a develpment server, and I use MS Access to prototype sql-server and vb apps. I very often notice an hourglass when doing simple things in Access--things that never, ever showed even a nanosecond of hourlglass on an older, slower 32 bit server. For instance, just saving a query will result in an hourlgass for several seconds, closing a small open table can do the same. The 64-bit sql-server instance on this box runs extremely fast, and the server runs beautifully for that purpose. From the MS Access standpoint, I don't have any of the 'Name-Auto-correct' or any of those other MS Access performance-hogging garbage 'features' set, and the Access .mdb is on the server's hd.
This box does not have any heavy processes running or active--it's basically idle as I work in Access, nothing else is really hitting the sql-server or anything else I can think of. The old 32 bit server I was using never showed any of these types of delays, and it was heavily used by numerous other developers who were constantly hitting it hard all day long.
So I'm just wondering if 32 bit apps actually run slower on this box due to the fact that they're not 64 bit apps.
Thanks,
--Jim
My question includes all 32 bit apps, but what prompted the question was a lot of hourglass time with MS Access 2003 when running on the 64 bit server. Is there some sort of 'emulation mode' or thunking that goes on when any 32 bit app runs on this server?
The server in question is a develpment server, and I use MS Access to prototype sql-server and vb apps. I very often notice an hourglass when doing simple things in Access--things that never, ever showed even a nanosecond of hourlglass on an older, slower 32 bit server. For instance, just saving a query will result in an hourlgass for several seconds, closing a small open table can do the same. The 64-bit sql-server instance on this box runs extremely fast, and the server runs beautifully for that purpose. From the MS Access standpoint, I don't have any of the 'Name-Auto-correct' or any of those other MS Access performance-hogging garbage 'features' set, and the Access .mdb is on the server's hd.
This box does not have any heavy processes running or active--it's basically idle as I work in Access, nothing else is really hitting the sql-server or anything else I can think of. The old 32 bit server I was using never showed any of these types of delays, and it was heavily used by numerous other developers who were constantly hitting it hard all day long.
So I'm just wondering if 32 bit apps actually run slower on this box due to the fact that they're not 64 bit apps.
Thanks,
--Jim
