urgent help required

  • hi ... wen i look at the 2 counters SQL Statistics\SQL Compilations/sec and SQL Statistics\SQL Re-Compilations/sec

    they are really high please let me know wat to do

    SQL Statistics\SQL Compilations/sec

    89.33433797

    359.3387341

    442.3387651

    186.8025799

    147.468242

    432.8066325

    442.4708407

    52.13413647

    0.399590578

    101.5614902

    382.2057551

    442.8050926

    146.3356983

    0.400005501

    0.400005168

    0.333337417

    126.9348094

    327.071228

    423.3367973

    195.7369697

    0.266670272

    0.400005126

    0.400004744

    0.400005519

    130.4682416

    279.7366969

    412.2057116

    229.1364798

    21.86696205

    0.399590218

    0.400003973

    0.266669323

    0.400006184

    0.400004384

    124.8017278

    275.1370436

    419.5376342

    228.8702232

    25.06696403

    55.20066994

    200.1357912

    371.9382048

    290.937263

    155.1351167

    229.4695118

    369.4048533

    228.1362697

    SQL Statistics\SQL Re-Compilations/sec

    3.600040485

    0.133335337

    0.266669941

    1.200016573

    145.6015554

    432.5399617

    442.3375061

    51.800798

    101.0287086

    381.6724137

    442.6717577

    146.0023596

    126.4014699

    326.6045548

    423.0701285

    195.4036302

    1.600019315

    67.6674803

    218.2696911

    228.8698095

    21.46695664

    274.6037031

    419.2709648

    228.6035524

    24.73362674

    54.60066266

    199.8691213

    371.471532

    290.7372603

    154.8017796

    176.4021548

    228.9361718

    369.2048507

    227.8029321

    69.1341086

    106.001115

    207.1365281

    308.4034884

    233.7364877

    216.2029792

    96.73448488

    205.8693599

    290.3370418

    242.6694644

    228.9368183

    6.93342548

    250.1365978

    442.0050806

    379.3378699

    20.93353657

    418.8064469

    442.4051596

    189.336227

    177.2024429

    427.4053306

    425.0056663

    41.86725106

  • please reply

  • Can you pls provide some more info?

    "Don't limit your challenges, challenge your limits"

  • Are your database stored procedures/adhoc-queries making too much use of "with recompile" clause in them?

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply