Welcome to Sign in | Help
in Search
Home Blogs External Feeds Forums Photos Downloads About Us
» Romanian Section » Intrebari » Re: Performante slabe SQL pe platforma 64

Performante slabe SQL pe platforma 64

Last post 12-04-2006, 12:30 PM by xmldeveloper. 19 replies.
Page 2 of 2 (20 items)   < Previous 1 2
Sort Posts: Previous Next

  •  11-09-2006, 10:54 AM 813 in reply to 812

    Re: Performante slabe SQL pe platforma 64

    Reply Quote

    Raid10 pt date si raid 1 pt log ar tb sa fie ok din cea am citit eu.

    Daca in conditiile astea interogarea nu-ti mere cum trebuie ar trebuie sa dai un shoiwplan la ea si sa analizezi rezultatele

    Secolul XXI ori va fi religios ori nu va fi deloc

  •  11-17-2006, 12:52 AM 901 in reply to 758

    Re: Performante slabe SQL pe platforma 64

    Reply Quote

    Presupun ca ai facut toate pregatirile necesare pentru  a rula un test de performanta (pregrow databse/log, MDF si LDF pe spindle-uri separate, workload identic). Si evident, rulezi pe acelasi hardware ambele teste.

    Ce versiune de SQL Server?
    Ce versiune de OS?
    Cita memorie fizica? Ce dimensiuni pagefile?
    Cum compari 32/64? WoW64 sau OS 32 nativ? Daca ai OS 32, boot-eaza cu /3GB sau nu? AWE on/off?

    Potzi face post la cite un perflog pentru fiecare test (32, 64) pentru SQLServe:Buffer Manager, SQLServer:Memory Manager, SQLServer:Wait Statistics, SQLServer:Databases, SQLServer:Latches, SQLServer:Locks. La toate selecteaza All Counters/All instances.

    Numai de bine,
    ~Remus



     



     

    http://rusanu.com

  •  12-02-2006, 5:19 PM 1167 in reply to 758

    Re: Performante slabe SQL pe platforma 64

    Reply Quote

    Un articol pe aceeasi tema: SQL Server becomes sluggish or appears to stall on 64 bit installations

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro

  •  12-02-2006, 5:35 PM 1168 in reply to 758

    Re: Performante slabe SQL pe platforma 64

    Reply Quote
    Un nou whitepaper va poate ajuta sa diagnosticati de unde provin problemele de performanta: SQL Server 2005 Performance Tuning using Waits and Queues (SQL Server - Best Practices)
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro

  •  12-04-2006, 12:30 PM 1190 in reply to 813

    Re: Performante slabe SQL pe platforma 64

    Reply Quote

    Referitor la configuratia RAID citez din Storage Top 10 Best Practices:

    Always place log files on RAID 1+0 (or RAID 1) disks. This provides:

    •

    better protection from hardware failure, and

    •

    better write performance.

    Note: In general RAID 1+0 will provide better throughput for write-intensive applications. The amount of performance gained will vary based on the HW vendor’s RAID implementations. Most common alternative to RAID 1+0 is RAID 5. Generally, RAID 1+0 provides better write performance than any other RAID level providing data protection, including RAID 5.

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
Page 2 of 2 (20 items)   < Previous 1 2
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems