InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 00:24:38 GMT20http://www.sqlservercentral.com/Forums/Topic1398068-5-1.aspx[quote][b]D-SQL (12/18/2012)[/b][hr]Datawarehouse recomended trace flags that need to be set to help performance [/quote]None, unless you are having specific problems that the traceflags address.Tue, 18 Dec 2012 16:22:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1398068-5-1.aspxneither of those two flags are going to have any significant performance gains:minimally logged inserts:[url]http://www.google.com/search?q=sql+server+trace+flag+610&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=[/url]grow the files at once:[url]http://www.google.com/search?q=sqlserver+trace+flag+1117&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=[/url]I'm skipping over the possibility of undersized hardware, memory, or slow disks as being the bottleneck for now.well, you can start right away with query tuning;the best thing to do would be to at least start looking at the top 20 poorest performing queries, see if they can be changed to SARGable arguments, see if indexes would help by looking at the [b]execution plan [/b];fix the items you can identify, and repeat the process over and over again.[code]SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDSELECT TOP 20CAST((qs.total_worker_time) / 1000000.0 AS DECIMAL(28,2))AS [Total CPU time (s)], CAST(qs.total_worker_time * 100.0 / qs.total_elapsed_timeAS DECIMAL(28,2)) AS [% CPU], CAST((qs.total_elapsed_time - qs.total_worker_time)* 100.0 /qs.total_elapsed_time AS DECIMAL(28, 2)) AS [% Waiting], qs.execution_count, CAST((qs.total_worker_time) / 1000000.0/ qs.execution_count AS DECIMAL(28, 2)) AS [CPU time average (s)], SUBSTRING (qt.text,(qs.statement_start_offset/2) + 1,((CASE WHEN qs.statement_end_offset = -1THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2ELSE qs.statement_end_offsetEND - qs.statement_start_offset)/2) + 1) AS [Individual Query], qt.text AS [Parent Query], DB_NAME(qt.dbid) AS DatabaseName, qp.query_planFROM sys.dm_exec_query_stats qsCROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qtCROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qpWHERE qs.total_elapsed_time > 0ORDER BY [Total CPU time (s)] DESC[/code]there's no easy way out, like a go fast button for SQL, sorry.[img]http://www.stormrage.com/SQLStuff/GoFastButton.png [/img]Tue, 18 Dec 2012 15:24:54 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1398068-5-1.aspxDatawarehouse recomended trace flags that need to be set to help performance We have a huge database and are looking for some performance help. Would data compression help? or setting specific trace flags? We set 610 and was asked about T1117Any Help is appreciated thanksTue, 18 Dec 2012 15:15:02 GMTD-SQL