[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 3177 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 200 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration
TPS Re-registration case still pending ..
What are your first memories of when Nepal Television Began?
निगुरो थाहा छ ??
ChatSansar.com Naya Nepal Chat
Basnet or Basnyat ??
Sajha has turned into MAGATs nest
NRN card pros and cons?
TPS EAD auto extended to June 2025 or just TPS?
मन भित्र को पत्रै पत्र!
Will MAGA really start shooting people?
Democrats are so sure Trump will win
Top 10 Anti-vaxxers Who Got Owned by COVID
TPS Work Permit/How long your took?
काेराेना सङ्क्रमणबाट बच्न Immunity बढाउन के के खाने ?How to increase immunity against COVID - 19?
Breathe in. Breathe out.
3 most corrupt politicians in the world
Dementia Joe has been selected to become the next President
आज बाट तिहारको सेल सकियो
TPS Renewal Reregistration
Nas and The Bokas: Coming to a Night Club near you
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