[Show all top banners]

the_hareeb
Replies to this thread:

More by the_hareeb
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 SQL server: Windows 2000 performance moniter question
[VIEWED 2983 TIMES]
SAVE! for ease of future access.
Posted on 09-09-10 1:27 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

I am trying to determine fill factor for my indexes. To do that I think the best idea is to use windows performance moniter to moniter the amount of reads and amount of writes. I have set up 2 counters:
'Disk Reads/sec' and 'Disk Writes/sec' from 'Physical Disk' performance object. I am running all this in a virtual box so that my sql server is not connected to any of the client softwares. So the only 'read' that will happen is when i run a query. My question is what about the writes?

Reason i ask is, when i look at the graphs i see there are some perks on the graphs(for writes) even if i dont do anything! what is the reason for that. Why is there an activity on 'writes' on my physical disk even if i dont do anything. When I run a query(ie read), there is a tweak on the read graph which makes sense to me. 



 
Posted on 09-09-10 4:38 PM     [Snapshot: 41]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

For Starters.. What is your current Index Fillfactor? What type of DB is this..Percentage of Read vs Writes ? Index FillFactor is directly proportional to Read and inv prop to Writes..So what this means if Fill factor is close to 100 % it means it is optimzed for Read, but it affects your write because any Insert you do will create page splits..So there is no magic bullet there..it all depends what you are trying to do...


Counters you mentioned measures Disk I/0 that is not exclusively for DB Disk I/0 so there must be something else that is causing writes/sec counter to spike,it may be nothing to do with your DB Disk I/O.In Windows Server 2008 there are ways in Task Manger to figure out what exactly is writing to Disk but don't remember in Windows 2000...


 
Posted on 09-10-10 8:49 AM     [Snapshot: 87]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Index fill factor is defaulted to 0 (same as 100%) I understand if i reduce it too low its gonna effect my reads. But my tables are being updated a lot so there is no point of having fill factor of 100% which is only stuitable for read only table. I was thinking something like 90%. But I need to look at performance moniter data to make sure. 

I have windows server 2000 and sql server 2005. Do you know what are counter measures to find out DB disk I/O in windows server 2000? thanks for input dashaiboka

 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 7 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
ढ्याउ गर्दा दसैँको खसी गनाउच
जाडो, बा र म……
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters