Tagged Questions
2
votes
0answers
99 views
Are the following statements concerning sys.dm_exec_requests true?
Parallel plans mean that cpu_time can be greater than total_elapsed time.
Therefore, per-query wait time is not possible to determine accurately from DMVs on servers with more than one CPU thread.
...
3
votes
1answer
114 views
SQL Server parallelism issue
I am rather new to SQL Server administrations, I am running an SSIS that never ends...
A) looking at the processes using
SELECT r.*, t.text
FROM sys.dm_exec_requests r
CROSS APPLY ...
3
votes
2answers
266 views
Parallel Statistics Update
In SQL Server 2008 or later, is UPDATE STATISTICS WITH FULLSCAN a single threaded operation or it can use parallelism? How about update statistics with default sampling - can it use parallelism? I ...
1
vote
2answers
465 views
Is problem with parallelism more common today than before? And what issues can arise from paralellism?
This is a very general question so I don't give much specific information. I am more interested in parallelism and its possible drawbacks. Generally I am all for parallelism as something useful and ...
4
votes
4answers
3k views
CXPACKET Waits performance tune for SQL Server 2008
I have a SQL Server 2008 query that is working on millions of records. The query is w/in a proc that is run nightly by a job. The query can take a full day to run when I first put it on the server, ...
5
votes
4answers
2k views
Parallelism Best Practices
What are the best practices with setting parallelism in general? I know that SQL Server defaults to 0 to use all available processors, but in what instance would you want to change this default ...
3
votes
2answers
135 views
Bizarre crash in T-SQL - what is it?
What would be a typical situation under which the following error would occur, and what does it mean?
Also note that I find myself disconnected from the server when the query fails (but I have not ...
