Topics
Started by
Posts
Last post
Hello Everyone, I have one Stored Procedure like below I am having two 18% Index Scan and sort 63% …
1 replies
Hi, We are experiencing the CXPACKET blocking/wait. We have Share Point 2007 SP1 databases on SQL …
8 replies
Hi I wonder if anyone can help me troubleshoot this deadlock? The input Buffer for SPID 829 is Proc…
10 replies
Hello, I know it's not easy to answer questions about performance tuning given the variations and u…
6 replies
Hi All, We have a database that is being used to collect data from around 3000+ user computers. The…
4 replies
Hi! Im trying to make a query better in my application through a peformance job. I got a good pla…
13 replies
I'm trying to get a handle on what constitutes a measure of work (to calculate comparative "workloa…
4 replies
New to perfmon logging. I have set up PerfMon to log stats to SQL. Now I'm looking at the data and…
2 replies
Is there a history table for activity monitor in 2005? Is there a way of going back to find out how…
2 replies
Its a general question regarding writing fatest performing tsql codes. Whats better ? To perform wh…
8 replies
where datediff(day, [field], getdate()) < 240 will force a scan (instead of a seek) but if the o…
23 replies
I understand CXPACKET waits are related to parallelism. Currently our SQL Server is set to use all …
7 replies
We have many databases at our company. There are two in particular both of which are on two differe…
14 replies
Switched a server to VMWARE and since batch running is slow. (I didnt want to put this heavy load …
1 replies
Hello As part of an investigation into some long running queries I created a trace in Profiler and …
2 replies
Viewing 15 topics - 1,021 through 1,035 (of 3,249 total)
You must be logged in to create new topics.