Stack Overflow
Stack Overflow

Questions tagged [database-tuning]

deals with optimizing the performance of a database. It can be about file design, and selection of the DBMS, OS and platform.

Database tuning is about maximizing the performance of a database. It can include hardware, software, file system, OS and DBMS selection. See the wikipedia article for more.

158 questions
1
vote
5 answers

How can I run SQL Profiler to a SQL SERVER from an external computer?

I want to run sql profiler to see the performance of my database Sql Server 2008, but I'm afraid that running the profiler in the same machine it will affect the performance of the server, and I don't want to slow down ther server. A long time ago I…
Artemination
  • 703
  • 2
  • 10
  • 30
1
vote
0 answers

SQLServer Table Partitioning

While using partition table SQL feature, I ’ve experienced strange behaviour. It seems that it’s better to insert rows into the table with while loop than inserting rows into the temporary table, and then at once insert from temporary table to…
Exerlol
  • 241
  • 3
  • 14
1
vote
1 answer

Group by too slow on Amazon RDS Postgres

I am running Postgres 9.4.4 on an Amazon RDS db.r3.4xlarge instance - 16CPUs, 122GB Memory. I recently came across one of the queries which needed a fairly straight forward aggregation on a large table (~270 million records). The query takes over…
Vaidhyanathan Srikumar Subrama
  • 11
  • 2
1
vote
2 answers

Optimizing mysql my.cnf - memory usage is dangerously high

I have tunet up mysql by following some tips on the internet. but the websites are loading slow and time time-to-first-byte is very high. therefore i started investigation and as far as i see, it is casued by mysql and high memory usage every time…
inventor
  • 55
  • 2
  • 3
  • 10
1
vote
1 answer

DB2 increase bufferpool size and compressed tables not equal better performance. Why?

I’m working on tuning and increasing the performance of my IBM DB2 version 9.7 database. I’ve been searching around the net for the last couple of days and learned that if I created my tables in COMPRESS mode and created one more bufferpool and set…
Emil Devantie Brockdorff
  • 4,724
  • 12
  • 59
  • 76
1
vote
2 answers

How can an improvement to the query cache be tracked?

I am parameterizing my web app's ad hoc sql. As a result, I expect the query plan cache to reduce in size and have a higher hit ratio. Perhaps even other important metrics will be improved. Could I use perfmon to track this? If so, what counters…
Bill Paetzke
  • 13,332
  • 6
  • 44
  • 46
1
vote
0 answers

SQL Server a lot of Single use objects

We have a database with about 50-60 % recompiles. That value comes from [SQL Compilations/sec] coupled with [Batch Requests/sec]. We Think that that value is a bit high If we look at this query: SELECT TOP 150 qs.plan_generation_num, …
Addeladde
  • 777
  • 2
  • 9
  • 28
1
vote
0 answers

MySQL: Buffer pool instance lookup

In MySQL V5.5.38, I have two buffer pool instances and when warmup sql was executed, data from a particular table was split among the two instances (identified this using innodb_buffer_page table) . Now, when I execute a query with a non-indexed…
Swathi
  • 11
  • 1
1
vote
0 answers

Tuning process exited unexpectedly.(DTAEngine)

I have tried to run the tuning advisor against multiple trace files and continually get the error "Tuning process exited unexpectedly.(DTAEngine). The server is running SQL 2012 SP1 CU9. I have tried running both as a sysadmin and as a user with…
Gikote
  • 11
  • 3
1
vote
4 answers

How easy (or otherwise) is it to to tune a database AFTER 'going LIVE'?

It is looking increasingly like I'll have to go live before I have had the time to tweak all the queries/tables etc, before I go live with a website (already 6 months behind schedule, so all though this is not the ideal scenario - thats how things…
Stick it to THE MAN
  • 5,621
  • 17
  • 77
  • 93
1
vote
1 answer

Neo4j 2.0.1 enterprise edition: Performance issue

I was happily using neo4j 1.8.1 community edition for a while on my system with the following configuration. System Specs: OS: 32-bit Ubuntu 12.04.3 LTS. Kernel version 3.2.0-52-generic-pae #78-Ubuntu Memory: 4GB Swap: 8GB (swapfile - not a…
new_sys_admin
  • 315
  • 2
  • 5
  • 15
1
vote
1 answer

I need a suggestion on query tuning techiniques

select /* all_rows */x1,x2,x3 from view_x where x1 in (select a.b1 from mytable a,mytable2 b where a.b2=b.c2) as view_x is a view, which is trying to get the data from the other source(@othertable_dblink) I have index on b1. but as view_x is a…
user3375522
  • 11
  • 1
1
vote
1 answer

Improving the performance of queries using SQL Server 2012?

I have a table which has 13,0000 records, but without indexing and I have written a query which has 4 LEFT OUTER JOINs. The query is working fine without any issue. My only concern is performance, it's taking 5-10 minutes to give the results. So my…
Sharad
  • 3,562
  • 6
  • 37
  • 59
1
vote
2 answers

Why does Postgres do a sequential scan where the index would return < 1% of the data?

I have 19 years of Oracle and MySQL experience (DBA and dev) and I am new to Postgres, so I may be missing something obvious. But I can not get this query to do what I want. NOTE: This query is running on an EngineYard Postgres instance. I am not…
RubyRedGrapefruit
  • 12,066
  • 16
  • 92
  • 193
1
vote
2 answers

Oracle Query/SQL tuning

I have a table with total 198695 records and 96579 records with project_id =555. I have list interval partitioned the table by project_id. If i run the below query(without distinct),it takes 0.75 secs to run. SELECT …
user2342436
  • 492
  • 3
  • 17
1 2 3
…
10 11