Re: How would the God of Standard Sql - Celko do server side paging?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'll elaborate for you. The report server lives on the same server as the database server, so the 1MM rows never reach the wire -- only the report..  Remote clients request reports and not rows. <<

How much of that mixed server work is doing done on VM Ware. et al
today? The outfit I worked with had separate hardware for the servers
and really, really fast connections between them. That was more a
matter of history than planning.

What interested me was a proposal they had for an analytic server. It
would be a box with floating point hardware and a honking big SSD.
That kind of specialized hardware is not something you could
virtualize effectively in software.

.

Relevant Pages

  • Re: 2008 SBS no longer boots
    ... driver issue initially, the fact that it seems to happen randomly now ... weird with a hardware problem that consistently doesn't get through boot ... other customer, even a 2 week old one, the problem immediately returned. ... There was a time when a server was fired up with a specialized OS and had a battery of tests run against each component to purposefully stress it. ...
    (microsoft.public.windows.server.sbs)
  • RE: Recommendation for 1000BASE-SX card?
    ... supported and drivers that aren't. ... on current versions of hardware. ... Cheapo crappy desktop gear, and expensive high quality ... into the high-end server market in a big way. ...
    (freebsd-questions)
  • Server crawls during backup
    ... It seems that the server freezes almost solid at times and then several ... Other than the problems during the backup it runs ... Information Store First Storage Group: A request to write to the ... Please contact your hardware vendor for further assistance ...
    (microsoft.public.windows.server.sbs)
  • Re: repeated failure of store - securty hack?
    ... Latest update I have the same MO appearing on another server, not related to or connected to the first one. ... Security logs show repeated logon logoff events, Store log files were corrupted. ... I have antivirus software running at the webhost for email, and for each workstation - not a free one. ... I am still not convinced that it is hardware - not on two different systems, ...
    (microsoft.public.windows.server.sbs)
  • Re: repeated failure of store - securty hack?
    ... Latest update I have the same MO appearing on another server, ... Store log files were corrupted. ... I have antivirus software running at the webhost for email, ... I am still not convinced that it is hardware - not on two different systems, ...
    (microsoft.public.windows.server.sbs)