Viewing 15 posts - 31 through 45 (of 63 total)
Thanks Gila, that clarified the issue.
Serter
September 30, 2010 at 6:26 am
Yes this would remove the blocking, I tried querying sys.partition with (nolock) by myself and its ok, but both blocked and blocking queries are from SCOM suite, I don't have...
September 14, 2010 at 3:37 pm
The case is, there is an sp named OperationsManagerDW.dbo.StandardDatasetMaintenance in OperationsManagerDW, which is called periaodically every 1 hour or so, this call blocks tempdb because of temp tables, and meanwhile...
September 13, 2010 at 12:17 pm
What I'm trying to figure out is if the blocking unavoidable in these circumtances? Should I contact with SCOM support? This does not look as SQL's fault..
September 13, 2010 at 12:08 pm
Yes, its create #temp in an explicit transaction, at one point an insert to temp table takes 30 minutes, so locking sys.partitions.. The queries are coming from System Center Operations...
September 13, 2010 at 12:05 pm
Hi Jeff, the blocking query from all blocking transactions report is:
INSERT #StateInterval (
ManagedEntityMonitorRowId
,IntervalStartDateTime
,IntervalEndDateTime
,HealthState)
SELECT
l.ManagedEntityMonitorRowId
,CASE WHEN l.[DateTime] <
@IntervalStartDateTime
THEN @IntervalStartDateTime
ELSE l.[DateTime]
END
,CASE WHEN ISNULL(r.
[DateTime], '99991231') >
@IntervalEndDateTime
THEN @IntervalEndDateTime
ELSE r.[DateTime]
END
,CASE WHEN l.NewHealthState >
ISNULL(r.OldHealthState,
l.NewHealthState)
THEN l.NewHealthState
ELSE ISNULL(r.OldHealthState,
l.NewHealthState)
END
FROM #StateEvent...
September 13, 2010 at 5:23 am
Also I observed that default collation for the database is significant for the part written in single quotes..
September 12, 2010 at 12:49 pm
SP1 has resolved some of the errors for me, now there is arithmetic overflow error, as I searched the internet, it is said SP1 CU8 is the cure, but I...
August 27, 2010 at 12:40 am
As I experimented with Turkish letters ç,s,ö,ü,g,i they are converted logically c,s,o,u,g,i (maybe because of an accent relation with latin letters), I guess this not so non latin-based alphabets..
August 24, 2010 at 12:48 pm
Hi, I want to understand what happens if the collation of a column Latin1_General (varchar), and if I write a query with a asian pictograph inside single quotes? As I...
August 24, 2010 at 12:26 pm
Luzi62 (8/24/2010)
August 24, 2010 at 6:40 am
I see but SSIS does not seem optimal for our case, let me clarify a bit more, I have two source tables and 15 destination databases (2 table each), I...
August 24, 2010 at 1:49 am
Hi ALZDBA What is the utility you use for getting these info? Thanks
July 30, 2010 at 12:58 am
Thanks Paul that was a very great explanation, so it is db engine that expects to find at least one row, in shorter time than index seek, and starts off...
July 29, 2010 at 8:35 am
Hi,
avg_fragmentation_in_percent : 0.4
SQL Server 2008 Enterprise SP1,
Our db engine chooses to clustered index scan beyond 250,000 lower than 250,000 uses the index (both using TOP 1); I guess...
July 29, 2010 at 5:46 am
Viewing 15 posts - 31 through 45 (of 63 total)