database-tuning

相关标签：javascript jquery android 多少钱 iPhone

Real Time issues: Oracle Performance tuning (types / indexes / plsql / queries)

I am looking for a real time solution... Below are my DB columns. I am using Oracle10g. Please help me in defining table types / indexes and tuned PLSQL / query (both) for the updates and insertion[详细]

2023-04-07 15:02 分类：问答
What values need to be least selected to optimize indexes with database engine tuning advisor

For MSSQL 2008 R2 database what values need t开发者_如何学Co be selected minimum to find required indexes when profiler trace given to the database engine tuning advisor ?[详细]

2023-04-07 04:38 分类：问答
How to see, what's *really* going on in a query execution?

In SQL Server 2008, I would like to examine what is really going on behind the scenes when a query is executed. Can I somehow see the following?[详细]

2023-03-20 18:04 分类：问答
Will SQL Server 2005 Database Engine Tuning Advisor "tune" Temporary Tables?

I\'m attempting to use Database Engine Tuning Advisor to tune my database.开发者_如何学GoFrom the comments it\'s logging (it\'s just 40% into the analysis, after running all weekend) it appears that D[详细]

2023-03-01 02:12 分类：问答
SQL Server: Number of disk blocks used by index or table

In SQL Server, how can I see th开发者_如何学运维e number of disk blocks an index or a tables uses?Using this query, you can determine the number of pages (8 KB blocks of space) a SQL Server table uses[详细]

2023-02-21 22:03 分类：问答
SQL Server Database Tuning Advisor Blocking Issues

This is occurring during the end of the analysis when the DTA开发者_如何学JAVA tries to drop the indexes it created.Unfortunately, with the database in use, this is causing terrible blocking issues.Is[详细]

2023-01-24 02:13 分类：问答
I can't find the SQL Server 2005 Database Tuning Advisor

I can\'t find the SQL Server 2005Database Tuning Advisor on my computer. Is it something I needed to specifically choose when I installed SQL Server 2005?[详细]

2023-01-23 04:48 分类：问答
Can "exec sp_reset_connection" be removed from SQL Server Profiler trace data before running the tuning advisor?

Based on information I have read about t开发者_如何转开发he \"exec sp_reset_connection\" which appears in SQL Server Profiler trace data when connection pooling exists, it seems safe--or logical, rath[详细]

2023-01-13 19:10 分类：问答
Undo changes made by SQL Server Database Tuning

I am not sure if this question can be asked here or serverfault. I开发者_如何学Python was wondering...Is there is a way to quickly undo the changes made by SQL Server 2005 Tuning Advsor other than rec[详细]

2023-01-13 13:12 分类：问答
Speed up Oracle Text indexing or let the indexer work only on low load times

We\'re using a Oracle Text CTXSYS.CONTEXT index to index about half a million rows containing metainformation. The information is spread over two tables that are combined by a procedure that the index[详细]

2023-01-08 00:42 分类：问答