Re: San Performace with SQl Server

Those stats do look poor for raid-1+0. I think I would consider more
read cache in that case. Also I would review the raid set
configuration. If you have large raid sets you may not be using read
cache effectively because large stripes may be read into cache for
small random reads which are expected with oltp. This sort of pollutes
your read cache with unnecessary data. Are your raid groups using
larger sets than 2D+2D? If so, consider a relayout where you're using
mostly 2d+2d.

Regards,
Vic Engle

.

Relevant Pages

  • Re: UltraController II + SystemAce
    ... the DONE pin going high doesn't really mean the configuration has ... that would use BRAMs instead of trying to fit everything in cache. ... planned to use UC2, but then switched to a regular PPC design with PLB_BRAM. ...
    (comp.arch.fpga)
  • Re: Write performance.
    ... cache on this box was pretty small. ... Can you tell me any other configuration parameters that I ... >> 5X more slowly with a simple SELECT query running in ... Does Sql Server hog performance ...
    (microsoft.public.sqlserver.server)
  • Re: UltraController II + SystemAce
    ... the DONE pin going high doesn't really mean the configuration has ... that would use BRAMs instead of trying to fit everything in cache. ... planned to use UC2, but then switched to a regular PPC design with PLB_BRAM. ...
    (comp.arch.fpga)
  • Need Help with Hibernate - "Not binding factory to JNDI, no JNDI name configured"
    ... I am experimenting wtih Hibernate and after working out all of the ... Security component's FFDC Diagnostic Module ... JAAS configuration information successfully pushed to login provider ... WebSphere Dynamic Cache initialized successfully. ...
    (comp.lang.java.programmer)
  • Need Help with Hibernate - "Not binding factory to JNDI, no JNDI name configured"
    ... I am experimenting wtih Hibernate and after working out all of the ... Security component's FFDC Diagnostic Module ... JAAS configuration information successfully pushed to login provider ... WebSphere Dynamic Cache initialized successfully. ...
    (comp.lang.java.databases)