The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
110 views

MongoDB 100% locked periodically. MMS charts attached

Trying to diagnose what could be causing intermittent lock-up on MongoDB server running behind a Rails application. Hoping that someone might recognise the pattern of peaks and troughs in the charts ...
1
vote
1answer
225 views

How can I tell if I would benefit from upgrading my Amazon RDS instance?

I have several sites with very high traffic - all hosted on Heroku and all of which access a db.m1.large mySQL Amazon RDS instance - and would like to know if there would be a performance benefit in ...
0
votes
1answer
57 views

Database server's Load reaches very high values while nothing seems to use CPU, what could be the reason?

top - 16:33:08 up 155 days, 6:05, 5 users, load average: 27.93, 35.31, 31.34 At this moment it only shows 27.0 but the behavior is like so: While mysqld uses 0% cpu the load raises to high values ...
0
votes
1answer
110 views

Server Performance

I know very little about performance tuning of servers etc... so i thought i'd put this up here as i start some research on it, just to get some direction. I am in the process of migrating from my ...
0
votes
1answer
67 views

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period ...
0
votes
1answer
144 views

Need help tuning Mysql and linux server

We have multi-user application (like MailChimp,Constant Contact) . Each of our customers has it's own contact's list (from 5 to 100.000 contacts). Everything is stored in one BIG database (currently ...
0
votes
1answer
457 views

What's throttling the database?

Hardware: Intel x86_64 with 192GB of RAM. OS: CentOS 5.4 x86_64. DBMS: DB2 v. 9.7.1 64 bit. During certain special workloads (e.g. parallel REORGs/RUNSTATs), I've seen the server transporting ...
-1
votes
1answer
483 views

MySQL runs at >=100% CPU, heavy disk I/O?

Recently my Debian Linux server has been experiencing slow web server response times. I've investigated and it seems that MySQL is the culprit, yet there are no slow queries indicated by the slow ...
2
votes
0answers
29 views

Exchange 2010 on KVM - CPU usage reporting incorrectly

Good Morning, I have virtualized an exchange server using KVM (proxmox actually). It is Exchange 2010 SP3 running on server 2012 R2. KVM version 1.7.1. I am using the latest (0.1-74) virtio ...
1
vote
0answers
171 views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
1
vote
0answers
463 views

SQL 2008 Database tuning advisor won’t start

For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying: Failed to initialize MSDB ...
0
votes
0answers
23 views

How to achieve optimal performance with Multiple MySql databases on 1 server

What would be the ideal MySql setup that improves performance given the constraint that 15-20 low volume apps cannot be divided into their own server? Inherited a setup containing many low volume ...
0
votes
0answers
19 views

Log ODBC queries including execution times to solve performance issue

We are facing some Perdormance issue in out web aplication which uses an ODBC Connection, i would like to log running queries to analyse where the problem is, Is there any way to make ODBC log the ...
0
votes
0answers
82 views

Disk IO slower when outstanding IO requests are less than 32

I moved the databases from one server to another and general remark from users is that its slower. The old server was on windows 2003,64 bit, SQL 2005 Ent edition(32 bit) whereas new one is Windows ...
0
votes
0answers
542 views

Cannot enlarge MySQL Innodb_Buffer_Size, causes MySQL to crash

I currently have innodb_buffer_size set to 2GB - yet I have well over 5GB of innodb databases, and another 4 gigs of free ram on the server (Centos 5). I tried to increase the value to 3 gig, but ...