424
Back to Top

HPE SiteScope Microsoft SQL Server 2005 Solution Template - license

Mfg. Part: T9485AAE | CDW Part: 2208683 | UNSPSC: 43232804
$5,793.99Advertised Price
Lease Option ($162.75 /month) Lease Availability
Close

Have leasing questions? Let us know how can we help.

Note: Leasing is available to businesses only. Leasing is not available to individuals.
800.800.4239
Mon-Fri 7am-7:30pm CT
Availability:1-3 days
Orders placed today will ship within 3 days
  • License
  • ESD
  • Win
View More
Product Overview
Main Features
  • License
  • ESD
  • Win
This agentless application monitoring software provides heterogeneous and hybrid support, quick time to value, and ease of installation, configuration, and use.

Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
System Requirements
Platform: Windows

Software
License Category: License
License Qty: 1 license
License Type: License

Header
Brand: HPE
Compatibility: PC
Manufacturer: HP Software
Model: Microsoft SQL Server 2005 Solution Template
Packaged Quantity: 1
Product Line: HPE SiteScope

General
Category: Networking applications
Electronic Distribution: Yes
Installation Type: Locally installed
Subcategory: Network - monitoring & performance management

Product Reviews
HPE SiteScope Microsoft SQL Server 2005 Solution Template - license is rated 3.8 out of 5 by 18.
Rated 4 out of 5 by from MySQL ? Sure, but what is the best config and how to optimize for best performance ? We could write books about MySQL ( https://www.itcentralstation.com/products/mysql ) and every book could have a different focus: setup, optimization, backup, etc.So, this review will be about sharing some experience I have had.So, MySQL is probably the most used RDBMS for web applications.The server is really easy to install, literally a straightforward installation.It is very fast and stable and at the same time not resource hungry compared to some other RDBMS products.For smaller projects, you will not even need to do any "after install" tweaks or configurations, just install and you are ready to go.Nevertheless, for some more demanding projects, you will need to investigate and optimize your setup to fit the requirements.What is the best configuration for a MySQL server?There is no single best configuration. There are many of them, depending what is MySQL used for.E.g., it is not the same as having it installed in a shared hosting environment or as a dedicated instance to just one application.Having 1000 of users using a few hundred different databases or having 20 users using one database.Is it gonna be an OLTP or OLAP, do you focus more on writing or reading?I will not dive into this, as there are many other articles covering this in a much better way than this article.But, starting by selecting the adequate storage engine MyISAM or InnoDB, defining the maximal number of connections, all the buffer and caching settings, limit on open files, table caching, etc. is laways a good approach.You will need to sit down and write down all the requirements known to you and then aligned to those, start configuring your server.A very handy tool to investigate your server's setup and performance is the mysqltuner.pl script.It can be used as a starting point to investigate your server setup and increase performance.Sometimes, although your server is configured properly, you might experience a slow performance, especially on a shared hosting server.During my career as a system administrator in a hosting company, we have monitored our MySQL servers and tracked the performance.Often, in such an environment, it might happen that you have a "running away" query, eating up your resources or causing performance issues.In such a case, database optimization is required, rather than server a config.A good example for this is having a well-visited web application with many concurrent users.Often on such an application, there are queries which run more frequently than others.E.g. presenting top 25 products in a web shop by using a query similar to this:SELECT p.name, c.nameFROM product pLEFT JOIN category c ON ( c.id = p.category_id )WHERE p.new_product='1'GROUP BY c.name, p.nameORDER BY p.name ASCLIMIT 25 ;Such queries will run very fast if the database itself is optimized.But otherwise, they can run really slow and cause high CPU utilization or in worse case a bottleneck and slow down the whole server.You don't need to have millions of records, this can happen even if you have only a few hundreds/thousand records in your database.In such case, you need to identify these "slow queries" (you can log slow queries) and then investigate the database they are referencing.Often it's about missing indexes on columns involved in GROUP BY, ORDER BY or WHERE clause.Backup? Of course, you already have the backup in place and it's running, at the end we are talking about the database.There is always a backup policy when a database is involved.Many use mysqlbackup command to schedule a "hot backup" of a server.Although it works in 99% of cases, please consider having a mysqldump running in parallel. Why?It might happen that you have a corrupted InnoDB tables and you are backing them up. By the first server reboot, it might lead that you lose data.When databases are involved, it is always good to have the data backed up in a flat structure if possible, if we are not talking about huge databases and the dump would consume too much time.This gives you the ability to import the data in a new instance, if you face any scenario where you have issues with corrupted storage engine and cannot recover from that.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-08-22
Rated 3 out of 5 by from Offers a simple DBMS solution with a very low hardware footprint. Only one of the engines supports ACID transaction control. Valuable Features:We design web solutions for customers with PHP (Linux) and ASP.NET ( https://www.itcentralstation.com/products/asp-net ) MVC (Windows). MySQL offers a simple, no frills, but effective DBMS solution with a very low hardware footprint. Since it has no licensing fees, it offers great TCO for our customers.Improvements to My Organization:We do software development for our customers on both Windows and Linux. Since these tools are available for both Windows and Linux, we can leverage the knowledge of these tools for development on both platforms.Room for Improvement:Only one of the engines, InnoDB, supports ACID transaction control. The best performance engine, MyISAM, has no transactional control support.It would make a lot of sense to include one engine that offers both very good overall performance and transactional control support.All versions of MySQL, including the Community Server version include in its design a Pluggable Storage Engine Architecture.This architecture allows for the support of multiple options of Storage Engines, so, a software architect can design a sofware solution with MySQL based on a specific Storage Engine that is capable to cater to a particular type of storage use case requirements, like for instance, web applications with heavy read workloads and moderate write workloads, or intranet desktop applications with heavy write workloads.Depending on the version of Community Server installed is the list of available Storage Engines: all it takes is the execution of the command SHOW ENGINES to retrieve the list of installed Storage Engine plugins.When you create any given table in MySQL, you have the option to select what Storage Engine (among the engines available) will be applied to said table. If this option is no explicitly mentioned at the end of the "CREATE TABLE" command, the current default storage engine will be assumed.For web apps with intensive read workloads and moderate write workloads, the engine that offers a good overall performance is the MyISAM engine, but this does not support ACID transaction control, and it uses a table-level locking mechanism (thus, from a performance standpoint, this is not proper for apps with heavy write workloads).The InnoDB engine uses a record-level locking mechanism, so, it is proper for apps with heavy write workloads. It also supports Isolation Levels, which is important for applications that have many clients doing read and write operations concurrently.The other storage engines offer support for very specific use cases, like for instance, flat file tables (CSV engine) or memory-only tables (Memory engine).Getting back to the InnoDB engine, it offers features that are similar to the database engine in SQL Server, and according to some of benchmarks that we have run, SQL Server Express provides overall better performance than MySQL Community Server with InnoDB tables.My "Room for Improvement" comment is that it would be great if in the future Oracle were to provide with the Community Server edition a version of InnoDB with better overall performance, while still requiring a small hardware footprint.Use of Solution:We have been using MySQL on both Windows and Linux for over six years.Stability Issues:As with any good DBMS, MySQL requires periodic DBA maintenance. If you leave a MySQL database with no supervision of a DBA for enough time, files become too fragmented and they may turn corrupt beyond rescue.Scalability Issues:The version of the product with free licensing does not offer stellar scalability support. We only use these tools for solutions that do not require such a level of scalability.Technical Support:The version of the product with free licensing only offers community forum support. Because it is a very popular product, there are many free resources on the internet to search for solutions to most issues.This kind of "free support" is OK, because we do not use these tools for mission critical solutions.Previous Solutions:For Windows development of non-critical solutions, we previously used SQL Server Express exclusively. However, now we use either SQL Server Express or MySQL, depending on the customer. We have not switched from SQL Server Express to MySQL.Initial Setup:The admin tools offered by MySQL Workbench are very good. For an experienced DBA, it is rather easy to setup a (MySQL) server for development, testing, pre-production, or production environments.Pricing, Setup Cost and Licensing:With no licensing fees, the business opportunity is great for both the customer and an ISV like my company. This is the case, as long as you use these tools for non-critical solutions.Other Solutions Considered:We did evaluate other solutions, mainly PostGre SQL ( https://www.itcentralstation.com/products/postgresql ), which is also a very good product.We run a benchmark comparison first, and then we run a small lab with the development of a small solution with both toolsets (MySQL and PostGre SQL).In this development comparison, we found that the winner is MySQL. MySQL toolset for development offers much more coverage for both PHP and C# development.Other Advice:Most small and medium enterprises require many non-critical solutions. They clearly they do not have large budgets for these kinds of solutions, so it makes a lot of sense to consider MySQL as a good option for this kind of development.The advice is to make sure that it works for your company and for your customers.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-08-01
Rated 4 out of 5 by from The most valuable feature is its graphical interface which allows us to do the database administration. Valuable Features:MySQL is strongly recommended for web applications and LAMP architecture systems. The most valuable feature of this product for me is its graphical interface which allows me to do the database administration easily. Another important feature is its reliability, the decent performance, and the fact that it is an open source product.Improvements to My Organization:It gives us the opportunity to create backups of our databases easily and loop through them with minimum effort.Room for Improvement:I think that the stored procedures and the development tools to write and debug large queries could be improved.Use of Solution:I have used MySQL for about ten years.Stability Issues:There were no issues with stability.Scalability Issues:There was no issue with scalability.Technical Support:We have not used technical support. The community is large enough to find the solution when something comes up.Previous Solutions:We used many SQL database solutions like PostgreSQL and SQLite and NoSQL databases like MongoDB. The choice depends on the project.Initial Setup:The initial setup was straightforward.Pricing, Setup Cost and Licensing:I think that the Open Source product would cover the needs of most projects. In some cases, the advanced features are needed. they could use the enterprise edition which is reasonably priced.Other Solutions Considered:We have evaluated and used different products like SQLite. It depends on the requirements and the needs of the project.Other Advice:I believe that it is the ideal solution for a variety of projects with a small learning curve compared to other solutions. It allows you to be efficient quickly.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-28
Rated 5 out of 5 by from Improved our internal procedures by providing high performance, ease of use and cost savings. Valuable Features:The most valuable features are:* MySQL Database Servers* MySQL Connectors* MySQL WorkbenchImprovements to My Organization:MySQL has improved our internal procedures by providing high performance, ease of use and cost savings.Room for Improvement:Security in the data files needs manipulation.Use of Solution:I have used this solution for five years.Stability Issues:There were no stability issues.Scalability Issues:There were no scalability issues.Technical Support:Technical support is excellent.Initial Setup:The setup was really straightforward.Pricing, Setup Cost and Licensing:According to the specific business and technical requirements, you can choose your MySQL Edition that you wish by consulting the official site.Other Solutions Considered:We looked at the Microsoft SQL Server.Other Advice:It can benefit any business by a straightforward way of implementing and using it.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-21
Rated 4 out of 5 by from Simple to use with excellent performance. Valuable Features:To me, MySQL is very flexible, has an excellent performance and it's simple to use.Improvements to My Organization:Once we needed to use a database to distribute a product for my company and we chose MySQL; It was easy to use, it is very small but powerful.Room for Improvement:Maybe the way to build clusters needs to improve, they could improve the installation process.Use of Solution:I been using MySQL for nearly seven years.Stability Issues:There were no stability issues.Scalability Issues:There were some scalability issues.Technical Support:I would give the technical support an 8/10 rating.Previous Solutions:We did upgrade the version by improvements in the product.Initial Setup:The setup was complex in the cluster installation.Pricing, Setup Cost and Licensing:MySQL is one of the best database options, the Community version is great.Other Solutions Considered:We used Oracle and SQL Server but their prices and licensing were so expensive.Other Advice:Using MySQL could be an excellent option.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-20
Rated 4 out of 5 by from Online backup can be implemented by activating a temporary storage and introducing Percona innobackupex. Valuable Features:This product is valuable because it is used in the production environments. Online backup can be implemented by activating a temporary storage similar to the Oracle's flash recovery area and introducing Percona innobackupex. This is possible from version 5.6.Improvements to My Organization:It permits services such as data warehouse and retail.Room for Improvement:The online backup needs to improve.Use of Solution:I have used this solution for 15 years.Stability Issues:We did encounter stability issues.Scalability Issues:There were no scalability issues.Technical Support:Not applicable because we don't purchase commercial support.Previous Solutions:We switched due to the cost saving reasons.Initial Setup:The setup was of medium-level complexity due to the memory parameters.Other Advice:Compared to PostgresSQL, it has an online backup feature only with the extension of Percona innobackupex.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-20
Rated 3 out of 5 by from Offers SQL Merge, Replication, and Views. I would like to see additional side management tools and IDEs. Valuable Features:* SQL Merge* Replication* Views* Stored Procedures* Triggers* CursorsThis is just like the enterprise grade Oracle DB. MySQL now supports replication (master-master or master-slave) of our DB to support our company's multiple geo-locations and PoPs.It supports the original Oracle SQL operations such as Merge, as well as the creation of Views to your tables. This brings additional convenience to our organization.Improvements to My Organization:The main benefit for us is that it's totally free, unless you need to pay for support.Room for Improvement:I would like to see additional side management tools and IDEs.Use of Solution:I used this current version for one year. I used previous versions for over ten years.Stability Issues:There were no stability issues.Scalability Issues:There were no scalability issues.Technical Support:We didn't need any technical support. I would guess that Oracle support is top-level.Previous Solutions:We did not use a solution prior to this one.Initial Setup:The initial setup was straightforward, user-friendly, and easy. In most cases, if you use the Linux-based versions, it comes as a standard Linux package. You can get it installed by using AptGet, Aptitude, or Yum.Cost and Licensing Advice:Just pay for any license if you need some enterprise support for your project or any additional support tools that Oracle ships with the enterprise version. During the development stage of your project, you can just use the free community edition.Other Solutions Considered:We evaluated MSSQL, Oracle DB, Informix, and MariaDB.Other Advice:Go with the Linux version. It is more stable and manages the system resources better.Disclaimer: My company has a business relationship with this vendor other than being a customer:We are partners, developing applications together.
Date published: 2017-07-10
Rated 4 out of 5 by from It is easy to understand the inner picture of the database from the EER model. Valuable Features:The EER diagram is the most important feature for me as the EER diagram can show the inner picture of the database, such as the relationship between the tables very easily. We can also add, modify or delete EER diagrams very easily.Improvements to My Organization:The user friendly interface which is easy to interact with such as creating backups, tables, views, and the EER model.Room for Improvement:It has lot of options to interact with. Sometimes it is hard to find the appropriate options quickly. They need to add descriptions somewhere as to where a user can go to find the proper menu easily when required. Another problem is that since all the databases can be seen and operated together, it’s possible to make mistakes such as dropping the wrong database.Use of Solution:I have used this product for two years.Deployment Issues:There was no issue with deploymentStability Issues:There were no issues with stabilityScalability Issues:There was no issue with scalabilityCustomer Service:The level of customer service is good. I understand sometimes they need to transfer the service to a knowledgeable person, so we need to have patience and explain the same problem several times.Technical Support:The level of technical services is good. I understand the product is technical, so sometimes the reported problem requires more investigation.Previous Solutions:I used phpMyAdmin. It is also a graphical interface but you have to buy the product while MySQL Workbench is free.Initial Setup:The initial setup is very straightforward. I didn’t face any problem at all.Implementation Team:I did the installation.Other Advice:This product is good as it is a graphical interface. It's easy to do all MySQL database administration very easily. You just need to play around to be more familiar with it. The MySQL Workbench interface is well prepared to design a database including EER diagram, create table, and view very easily. The EER diagram allows the user to completely understand the database design, which is very important and useful for the people who are involved with the database. It’s easy to understand the inner picture of the database from the EER model.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-10-29
  • y_2017, m_11, d_22, h_21
  • bvseo_bulk, prod_bvrr, vn_bulk_2.0.3
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_18
  • loc_en_US, sid_2208683, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw
 
Adding to Cart...
11/23/2017 5:00:24 PM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.

Error!

Something went wrong.

Please try again later.