Archive for November, 2011
SQL Server Tuning – The Top 5 Most Common Mistakes
First Misdiagnosis memory problems caused by I / O bottlenecks
Very often I see companies in which the DBA had problems with the server out of memory and decided to add more storage … sounds like an obvious, is not it? In fact, the first place to look to solve problems your memory I / O. If the tail is more than one plate 2 is to be solved this problem first. What happens is that the queue is the backup disk, and memory is used to hold the overflow. Many times when you solve the problem of hard disk, the problem of memory.
Second Not properly allocate memory in Windows
I can not count how many times I Server databases, see the suffering of hunger of memory. See if you found this sound familiar … They have a database server with 4 GB of RAM and time she has extremely slow. The Company does not invest in more RAM, because it also changes the editions of Windows to support the additional RAM. A simple answer to this is to use it, 3G / or / USERVA in the boot.ini file. It changes the way Windows allocates memory in user mode and kernel mode. Read the rest of this entry »
The Benefits of Shopping Cart Software
So you have a website, and you want to make a transaction, but what are the benefits and why you should make the leap from the brochure or lead generation for e-commerce?
What is software Cart?
Shopping carts and e-commerce, because it was also, as we know, refers to a special website that the software uses e-commerce shopping cart, to facilitate the process of buying and selling of products or services over the Internet.
CRM
To the basket and cutting-edge software solutions include e-commerce modules of Customer Relationship Management that you keep track and record customer information allows you to targeted marketing campaigns via e-mail on the move to create sales and build customer loyalty. Read the rest of this entry »
Activity Monitoring for Database Management
First Event recording (on the host server)
Second Passive monitoring of network traffic on the host server
Third Agents or client software on each computer. Read the rest of this entry »