Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Compatibility Server x86 and Clients x64 bits. Expand / Collapse
Author
Message
Posted Friday, March 8, 2013 10:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 10:37 AM
Points: 2, Visits: 25
Hi folks,

I have a SQL Server 2005 x86 in my Windows 2008 Server x86.

I have one Client Application Win32 developed in .Net with NHbibernate.

This app does a lot of queries (about 1000 selects) to the SQL Server.

I have 2 clients pc. First one with windows XP x86 and the last one with Windows 7 x64.


The problem is the next:

1. I go to the SQL Profiler into the server.
2. Execute the client app in the WinXP x86.
3. The "Selects" in the profiler are shown and executed very fast and the app works inmediatly.

4. Execute the client app in the Win7 x64.
5. The "Selects" in the profiler are shown and executed too slow (1 select at the time) and the app doesnt respond.


So, If I have the same APP win32 and the same SQL Server.. WHY does it happen?
Does it depend on the SQL Native Client?
Should I install the App in only Client SO x86, i mean should I format the win7 x64 pc and install the win7 x86 S.O.?

Please, answer me.

Best Regards,

Post #1428701
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse