Create tutorial regarding top 10 performance counters for software/hardware/network/web server/SQL database

Cancelled Posted Jan 21, 2014 Paid on delivery
Cancelled Paid on delivery

I would like tutorials regarding performance counters for the most commonly used counters (top 10) to detect load problems on software/hardware/network/web server/SQL database. I would also like a tutorial on how to test and monitor the stuff talked about in here (how changes in config will affect results seen in perfmon): [url removed, login to view];en-us;821268

In order to get me interested in working with you, you'll just need to IM me with a few links of what you can find on the internet that has counters that you think are important for constant monitoring when deploying new software, when running load tests, etc., that will be useful to identify problems before it happens, to plan for sustenance and expansion. (Note: I already have some of the links I like, I need you to send those info so that I can determine if you're spamming me, or you actually read my post. Therefore, the IM should just have the links so that I can determine quickly who read my post, within a few seconds.)

For the tutorial videos, I don't need nice graphics. When you do the video record, you'll need to record the sketches you do, while you explain the material, that's good enough. Therefore, an additional requirement for initial IM is for you to send a recording of you reading this sentence to me. For the final deliverable, you'll also need to write sample code that will generate load, and demonstrate how that counter will change with different load, how to interpret the data, and when it's a problem. I will expect that I can reproduce what you've demonstrated, if I create a virtual machine with pretty low specs (I'll probably use VirtualBox), and try to hit certain performance bottlenecks using the code you provide. You can also include a short quiz at the end of each tutorial for the viewer to make sure they grasped the main content (optional).

You will not need to go into code profiling/etc. - just stick solely to Windows perfmon. Some counters related to software are like CPI (not sure if it's in perfmon though, however, if you know of a similar counter, lmk). The video should include nuances that one should know about when looking at the counter. For example, I don't know what other conditions might lead to the SQL lock count being high besides bad TSQL/SP design. If you know of this, include it. These are the types of information that should be included in the tutorial. Another thing is that I don't know much about computer architecture, so explaining the "what's going on in the computer"/behind the scene/inner working, etc. of how the counter is generated/what will cause certain conditions to be triggered, etc. will help. For example, for counter Memory : Page Faults/sec, you can go over memory architecture - register, L1, L2, L3, disk drive, etc.(graphic drawn here/from online), how if stuff are not in memory, it has to go to a hard disk, and that's a page fault, etc., so we want to keep this number low. Tell me how to find out/know if a value is expected (in the case above, what's a "low" value? what does this depend on? where to look?, etc.) Then, write a program that might cause a lot of paging vs. not (if applicable).

I think there will be a total of around 100 counters. Please give me a quote for videos for all 100 counters, code, etc., as requested. When we do work on it. I will need the video one at a time (I will not wait for the full 100 videos), highest priority first, so that I can determine if we have a good working relationship, and let you proceed or not.

One last thing is that I'm very big on communication and trust. If you don't understand, and you ask me first, I'll be very happy to answer questions, but if you make me have to ask questions and probe to find out that you don't fully understand, that can ruin my trust for you very quickly, and I'll probably cancel the project if I feel like I can't trust you to honestly tell me yes/no/you understand something/or not.

Thank you.

C# Programming Education & Tutoring SQL System Admin Videography

Project ID: #5342451

About the project

2 proposals Remote project Active Jan 31, 2014

2 freelancers are bidding on average $521 for this job

elboukharimu

Hi, I'm very interested helping you creating your SQL database tutorials, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to chec More

$526 USD in 10 days
(15 Reviews)
4.6