2
votes
1answer
95 views

Does Windows Server File Compression slow Oracle DB performance?

I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure. I can ...
0
votes
1answer
307 views

Postgres 8.3 faster than 9.3?

Our software product currently ships on Windows 7 with Postgres 8.3 as its database. On a busy site, there may be 24 automated systems generating 100 rows (x100 columns) per minute, with 3-10 human ...
3
votes
2answers
8k views

MySQL creates temporary tables on disk. How do I stop it?

We are running a site (Moodle) that the users currently find slow. I think I have tracked down the problem to MySQL creating temporary tables on disk. I watch the variable created_tmp_disk_tables in ...
0
votes
1answer
491 views

MongoDB Master and Slave Replication - Windows or Linux

I have recently moved my MS SQL Server Database to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
0
votes
0answers
71 views

Long disk queue when no traffic

I got dedicated disk (RAID 10 - 4 SAS disks) for Postgres. I am bit worried as recently, I see under Windows Resource Manager disk queues like 3+ in the mornings (low traffic hours), like every 30-60 ...
3
votes
1answer
1k views

How to find the detail cpu high process name which occupying most resource in the SQL Server database?

I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env. DECLARE @ts_now bigint; SELECT @ts_now = cpu_ticks / CONVERT(float, ...
2
votes
1answer
412 views

Can I choose which CPUs / Cores to be used by MySQL?

I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example). With ASP.NET, in such situation, I usually set the app ...
1
vote
1answer
175 views

Appropriate Windows version for Mysql

I have a HP ProLiant DL380 G5 server and I would like to install mysql on it . My questions are: Which MySQL version should I install from this link for better performance, 32 bit or 64 bit? Which ...