Re: SQL client runs better on Vista over XP?



Ah, generally, Vista systems have more RAM. More RAM makes SQL Server faster. Vista systems generally have faster processors and more sophisticated hardware which can help the application run faster but I would not have expected these differences to make an application run much faster (not more than 10-20%).

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

"bruce" <bruced@xxxxxxxxxxxxxxx> wrote in message news:eR2XZjlwIHA.4560@xxxxxxxxxxxxxxxxxxxxxxx
My client has a 3rd party app with SQL 2005, (using SQL, not Windows authentication) as the backend and mostly XP Pro workstations, two with Vista Business, all with Gigabit Nic's. Every screen that involves database queries runs faster on the Vista's (or on the SQL server itself), the developer says they know of know reason, and in fact don't really support it on Vista yet. Anyone have any brilliant ideas why this may be the case, or how to track it down? Thanks.

.



Relevant Pages

  • Re: SQL Server 2000 and Memory
    ... There is a long and involved debate over what should be 'install' and what ... there should be an external configuration ... I support the Professional Association for SQL Server ... RAM usage just slowly grows until everything starts swapping out ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 and Memory
    ... they need the full SQL Server due to the database size but the daily volume ... website is meant for embedded database type applications. ... RAM usage just slowly grows until everything starts swapping out to ... > constant so giving back memory is not a big issue. ...
    (microsoft.public.sqlserver.server)
  • Re: INSUFFICIENT MEMORY
    ... That's totally dependant on how the data is structured, how the app is ... a certain amount of ram to operate properly. ... Andrew J. Kelly SQL MVP ... >> the standard editions of the OS and SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server Express Edition
    ... You are correct that Expresss will only use 1GB of RAM; ... Scaling Up on SQL Server especially from an Access DB will also warrant more ... Best Practices for both safety and performance. ... Perhaps I'd be better off with the Workgroup Edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL performance und cluster question
    ... Real-world stuff I run across with SQL Server: ... I install a new SQL cluster so I have a high-availability ... I can take 4GB RAM in the machines, more does Windows x86 not support ... the server hardware get out of service so we have to buy new ...
    (microsoft.public.sqlserver.clustering)

Loading