 WebProWorld
Dev Forum |
images disappearing+ code too ??
At the bottom of the left hand column is a screenshot image.gif, when i view it on my laptop this image file disappears, I view source and the url to the image file is also gone.
mail to form -- block senders
use a "mail to" form on my web site for visitors to send me messages. There is a company in Korea that regularly sends extremely long messages in jaberwoky, except for the links they contain.
What is the best include method?
I currently have several sites running and I use php to make includes within all sites on the server. This is all cool and makes things very easy and all, but I have a problem...
|
|
|
|
Recent Articles |
Crystal Reports - Microsoft SQL Server
Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few.
Daffodil's Free Java Database
Daffodil Software announced the launch of One$DB, a free version of its Java database - Daffodil DB. One$DB is exactly the same as Daffodil DB, barring a few features such as Full Text Search, Persistent Stored Modules and Row Sets. In spite of these features being excluded, One$DB still remains comparable to the best that the Java database market has to offer.
Microsoft Navision Integration with Microsoft RMS
Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). Currently Navision is supported on two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server.
SQLBase for Linux Novell Ready
Gupta Technologies its' SQLBase 9.0 for Linux product has just been certified "Novell Ready" for SUSE LINUX Enterprise Server 8 and 9. Novell Ready products enhance data systems with technology specifically designed to work with Novell's Linux family of enterprise-class products. Companies can achieve maximum synergy by teaming software and hardware solutions with Novell technologies.
Oracle Sets World Record
Oracle announced a world record 2-processor benchmark on Linux that placed Oracle Database 10g Standard Edition One (Oracle Standard Edition One) in the coveted Top Ten TPC-C by Price-Performance category. This record benchmark is the best price-performance ever on a 2-processor system, proving Oracle's ability to deliver exceptional performance and value on low-end servers. Using an HP Integrity rx2600 server with two Intel Itanium 2 processors at 1.3 GHz each with 3 MB L3 cache running on Red Hat Enterprise Linux...
Microsoft Navision Database: C/SIDE or MS SQL Server - Overview for IT Specialist
Microsoft Business Solutions promotes Navision (former Attain) on US market as excellent manufacturing applications (formerly it was promoting Great Plains). Navision is available on its native (solid rock and recommended databse) and Microsoft SQL Server. You should consider several factors in deciding on the database selection. Currently Navision is supported on two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server.
MySQL Partner Program Continues to Grow
MySQL AB has signed a Value-Added Reseller (VAR) agreement with GoldenGate Software who will become a Certified ISV Partner for MySQL. GoldenGate's Transactional Data Management software platform captures, routes, enhances and applies transactional data in real time...
|
|
|
|
12.09.04
Using Performance Monitor To Identify SQL Server Hardware Bottlenecks
 By Brad M. McGehee
The best place to start your SQL Server performance audit is to begin with the Performance Monitor (System Monitor). By monitoring a few key counters over a 24 hour period, you should get a pretty good feel for any major hardware bottlenecks your SQL Server is experiencing.
Ideally, you should use Performance Monitor to create a log of key counters for a period of 24 hours. You will want to select a "typical" 24 hour period when it comes to deciding when to create your Performance Monitor log. For example, pick a typical business day, not a weekend or holiday.
Once you have captured 24 hours of Performance Monitor data in a log, display the recommended counters in the Graph mode of Performance Monitor, and then record the average, minimum, and maximum values in the table above. Once you have done this, then compare your results with the analysis below. By comparing your results with the recommendations below, you should be able to quickly identify any potential hardware bottlenecks your SQL Server is experiencing.
How to Interpret Key Performance Monitor Counters
Below is a discussions of the various key Performance Monitor counters, their recommended values, and some options for helping to identify and resolve the hardware bottlenecks. Note that I have limited the number of Performance Monitor counters to watch. I have done so because our goal in this article is to find the easy and obvious performance problems. Many other Performance Monitor counters can be found discussed elsewhere on this website.
Memory: Pages/sec
This counter measures the number of pages per second that are paged out of RAM to disk, or paged into RAM from disk. The more paging that occurs, the more I/O overhead your server experiences, which in turn can decrease the performance of SQL Server. Your goal is to try to keep paging to a minimum, not to eliminate it.
Assuming that SQL Server is the only major application running on your server, then this figure should ideally average between zero and 20. You will most likely see spikes much greater than 20, which is normal. They key here is keeping the average pages per second less than 20.
If your server is averaging more than 20 pages per second, one of the more likely causes of this is a memory bottleneck due to a lack of needed RAM. Generally speaking, the more RAM a server has, the less paging it has to perform.
In most cases, on a physical server dedicated to SQL Server with an adequate amount of RAM, paging will average less than 20. An adequate amount of RAM for SQL Server is a server that has a Buffer Hit Cache Ratio (described in more detail later) of 99% and higher. If you have a SQL Server that has a Buffer Hit Cache Ratio of 99% or higher for a period of 24 hours, but you are getting an average paging level of over 20 during this same time period, this may indicate that you are running other applications on the physical server other than SQL Server. If this is the case, you should ideally remove those applications, allowing SQL Server to be the only major application on the physical server.
If your SQL Server is not running any other applications, and paging exceeds 20 on average for a 24 hour period, this may mean that you have changed the SQL Server memory settings. SQL Server should be configured so that it is set to the "Dynamically configure SQL Server memory" option, and the "Maximum Memory" setting should be set to the highest level. For optimum performance, SQL Server should be allowed to take as much RAM as it wants for its own use without having to compete for RAM with other applications.
Memory: Available Bytes
Another way to check to see if your SQL Server has enough physical RAM is to check the Memory Object: Available Bytes counter. This value should be greater than 5MB. If not, then your SQL Server needs more physical RAM. On a server dedicated to SQL Server, SQL Server attempts to maintain from 4-10MB of free physical memory. The remaining physical RAM is used by the operating system and SQL Server. When the amount of available bytes is near 5MB, or lower, most likely SQL Server is experiencing a performance hit due to lack of memory. When this happens, you either need to increase the amount of physical RAM in the server, reduce the load on the server, or change your SQL Server's memory configuration settings appropriately.
Physical Disk: % Disk Time
 This counter measures how busy a physical array is (not a logical partition or individual disks in an array). It provides a good relative measure of how busy your arrays are.
As a rule of thumb, the % Disk Time counter should run less than 55%. If this counter exceeds 55% for continuous periods (over 10 minutes or so during your 24 hour monitoring period), then your SQL Server may be experiencing an I/O bottleneck. If you see this behavior only occasionally in your 24 hour monitoring period, I wouldn't worry too much, but if it happens often (say, several times an hour), then I would start looking into finding ways to increase the I/O performance on the server, or to reduce the load on the server. Some ways to boost disk I/O include adding drives to an array (if you can), getting faster drives, adding cache memory to the controller card (if you can), using a different version of RAID, or getting a faster controller.
Before using this counter under NT 4.0, be sure to manually turn it on by going to the NT Command Prompt and entering the following: "diskperf -y", and then rebooting your server. This is required to turn on the disk counters on for the first time under Windows NT 4.0. If you are running Windows 2000, this counter is turned on by default.
Read the rest of the article
*Previously published at SQL-Server-Performance.com
About the Author:
Brad M. McGehee is a full-time DBA with a large manufacturing company, and the publisher of http://www.SQL-Server-Performance.Com, a website specializing in SQL Server performance tuning and clustering. He is an MVP, MCSE+I, MCSD, and MCT (former).
Brad also runs another website called http://www.WorldClassGear.com It provides independent gear reviews for backpackers, trekkers, and adventure travelers. |
