hello guys,
I've replace old SCSI disk with new SSD sata on HP proliant wth P420i controller (1Gb cache), server has 32Gbyte ram and DB has only 20Gbyte, benchmark test with SQLIO has very good result for SSD disk, it seems about 10 times better than scsi in read access (random and seq) but if I run a simple query on table with 4 milion rows it did result same as old scsi disk (2 minutes).
How can give me this result ?
Disk Alignment is correct, SQL server is Standard edition.
Show us the query and the execution plan in XML format. I suspect your query or your indexes need to be modified. What is the query waiting on when you run it?
Hi,
There are three factors you need to consider here: 1>> The size of your database 2>> The amount of memory you have in the server 3>> Your my.cnf configuration, specifically innodb_buffer_pool_size
Quey has been executed on local server, so there isn't possible network bottleneck.
I think all DB is loaded on ram, and query is the same performance. Is possible?
there is a command to know if table is loaded in memory or using disk access?