April 20, 2009 at 5:18 am
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
April 20, 2009 at 5:43 am
please reply
April 20, 2009 at 6:05 am
Can you pls provide some more info?
"Don't limit your challenges, challenge your limits"
April 20, 2009 at 4:59 pm
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