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
votes
2 answers

How to commit the transaction that are in idle state in PostgreSQL?

Is there a way to commit a transaction that is in an idle state in Postgres? If we use idle_in_transaction_session_timeout it kills and rollbacks the transaction, but is there any way to commit and complete the session, I can't see any blocked by…
Sujeet Chaurasia
  • 97
  • 8
-1
votes
1 answer

SPROC Slow from .NET but 5 times faster from SSMS

I have followed answers to similar questions already, including setting ARITHABORTH ON/OFF, clearing out buffers using DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE. Also tried converting parameters to local variables. But still having performance…
Arvind S
  • 87
  • 1
  • 7
-1
votes
1 answer

My search is very slow in sql server

I have a table as you can see in my sql server : CREATE TABLE [dbo].[Cars]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [VIN] [nvarchar](max) NULL, [ChassisNumber] [nvarchar](max) NULL, [PlaqueCoded] [nvarchar](max) NULL, …
Ehsan Akbar
  • 6,977
  • 19
  • 96
  • 180
-1
votes
1 answer

Performance Tuning on Update query

My simple update query takes too long to execute. There're around 10m records- out of those I'm executing for 1k records only. Statement is like this: UPDATE tab SET col1= 'yes', col2 = 'yes' WHERE col7 ||'_'|| col8 = 'VAL_0' AND col10…
inityk
  • 476
  • 1
  • 9
  • 18
-2
votes
1 answer

performance tuning of my sql in 12 GB ram with 21 Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz

Hi are trying to optimize MySQL for a huge traffic web server, we are using Apache 2.4 , and MySQL 5.6 version. We have put these parameters in MySQL configuration file cat /etc/my.cnf [mysqld] skip-external-locking key_buffer =…
rishi dadwal
  • 41
  • 1
  • 2
-2
votes
1 answer

How do you troubleshooting and tune oracle without oracle diagnosics pack and tuning pack?

How do you troubleshooting and tune oracle without oracle diagnosics pack and tuning pack?
betty
  • 25
  • 2
-2
votes
1 answer

Oracle 11g database server parameter tuning

I have a 4 Core 12GB RAM dedicated windows machine.I have Oracle 11g installed on it. Could any body please help on the DB server parameters that can be tuned from a performance perspective. Any reference to a credible url also is fine & will be of…
srj
  • 11
  • 7
-3
votes
1 answer

Best way to read a large csv (10gb) and after computation store the data in db

I have ~4gb of text file which I parse and save the data in a db. This process almost take 3-4hr(5-6 million lines) to process and save data in db. And this is a everyday process. Now when I query the db its taking too much time to compute result…
A J
  • 3,684
  • 2
  • 19
  • 24
1 2 3
…
10
11