May 11, 2009 at 12:44 pm
I have it as one file and it 102,400 kb, how I send it or export it first?Thank you
May 12, 2009 at 9:15 am
May 12, 2009 at 9:57 am
Ok,how can I exported to you?
May 12, 2009 at 9:59 am
Attach it to this thread in your next post. Underneath the message window, there is a post options section where you are able to add attachments.
May 12, 2009 at 1:26 pm
Thank you I loaded
May 13, 2009 at 9:22 am
May 13, 2009 at 9:34 am
Thank you:-)
May 14, 2009 at 8:52 pm
I just started to look at the file. There's an awefull lot of data here. It looks like you've captured about 40 hours worth of data. That will take a bit to go through and segment out into useful chunks. I'm already seeing some things that concern me, but a timeframe this large tends to skew the results a bit. Can you tell me a bit about the application and what time frames you would consider peak times for volume? What about slow time?
It helps a bit to know when your peak times are because it becomes very useful to know how your system resources are affected during your highest loads. It also helps to know how it performs under light load so you have something to compare it to.
Anyhow, let me know about your load times and I'll get you a quick write up on what I'm seeing.
May 15, 2009 at 7:03 am
Peak time from 6a.m
-5p.m, very busy 11-2, 6-12p.m. Thank you
May 17, 2009 at 9:42 pm
Here's a breakdown of the counter values for your busy times. I don't see anything here that concerns me. The average values for Lazy Writes /sec are a bit high, but none of the other memory related counters are out of the norm so I would not be concerned.
I would say that your system is using its resources well and there is no need for upgrading so you can add memory. I would advise you to re-run the monitor if you get complaints of slowness. That way, you can look at the performance metrics during the reported slow times.
Time Slice - 10:46 - 2:30
Avg Disk Queue Length
Min: 0
Max: 5
Avg: 0
Buffer Cache Hit Ratio
Min: 96
Max: 100
Avg: 100
Lazy Writes
Min: 0
Max: 155
Avg: 16
Page Life Expectancy
Min: 8
Max: 171276
Avg: 578
Time Slice - 5:30 PM - 12:30 AM
Avg Disk Queue Length
Min: 0
Max: 9
Avg: 0
Buffer Cache Hit Ratio
Min: 93
Max: 100
Avg: 100
Lazy Writes
Min: 0
Max: 142
Avg: 14
Page Life Expectancy
Min: 17
Max: 361998
Avg: 732
If you have any question about these values, just let me know. Here's how I came up with them.
1. Open up the Windows Performance Monitor.
2. Right-click in the monitor area and go to properties.
3. Go to the Source tab. By default, Current Activity will be checked.
4. Select Log Files. This should enable the 'Add....' button.
5. Select the 'Add...' button and browse out to find your performance log.
6. Once you've opened the log, press the Time Range button. You'll see that it will show you the Begin and End times for your file.
7. You can drag the time range control to specify a specific time range within your file.
8. On the Data tab, you'll see the default values that Performance Monitor uses. Remove these, then select 'Add...'. Add in each of the counters that I've shown above.
9. You can then look at the values for that time slice.
May 18, 2009 at 7:31 am
Thank you very much for your help.Can you please tell me besade on this report, how would I know if there is something wrong?
June 29, 2011 at 3:50 am
Hi Here is a query which I would use to get the Buffer Cache Hit Ratio informations.
SELECT
(CAST(SUM(CASE LTRIM(RTRIM(counter_name)) WHEN 'Buffer cache hit ratio' THEN CAST(cntr_value AS INTEGER) ELSE NULL END) AS FLOAT) /
CAST(SUM(CASE LTRIM(RTRIM(counter_name)) WHEN 'Buffer cache hit ratio base' THEN CAST(cntr_value AS INTEGER) ELSE NULL END) AS FLOAT)) * 100
AS BufferCacheHitRatio
FROM
sys.dm_os_performance_counters
WHERE
LTRIM(RTRIM([object_name])) LIKE '%:Buffer Manager' AND
[counter_name] LIKE 'Buffer Cache Hit Ratio%'
Regards
Imran Nadeem
June 29, 2011 at 7:49 am
I get 99.8728948204639,is this ok?
Also it is showing standard for 12gb is 10600(max memory setting and I have sql standard, I am afraid now to change to 10600, can I
change it for now to 5900?
Thank you
Viewing 13 posts - 31 through 42 (of 42 total)
You must be logged in to reply to this topic. Login to reply