Anyone here knows how to interpret the counter type 1073874176 of sys.dm_os_performance_counters ? There is little document on this. I googled a lot,...
Well, find out what's going on. When I loaded a huge test table, the SQL Memory Manager/Total Server Memory was climbing as well. I can see SQL25...
Just installed the Sql 2005 Standard Edition + SP2 on Windows Server 2003 R2 + SP1 (8GB memory + 2 dual core Xeon CPU) I use local system to start...
My SQL Profiler catches a couple of Lock<img src='/community/emoticons/emotion-2.gif' alt=':D' />eadlock Chain event. The weird thing is that the...
One of our SQL box is running extremely slow. It has four CPUs. Some one suggested that we should take one CPU off, so that OS can use it dedicately....
I need some advice. Basically, we have two databases: One is Oracle 9 for OLTP and the other is MS SQL for reporting. We plan to export all changes...
Can anyone suggest a nice third party tool to monitor SQL performance ?
thanks.. Since this OS has AWE enabled which maps & unmaps memory, anything I should pay particular attention ?
We have a dedicated SQL Cluster with 8GB memory, AWE enabled, 4 processors. It's passive/active Recently, we have users complain the slowness of the...
There is no tempdb inside the SP.
This SP has three updating statements inside. The trace show each updating requires either Clustered or non-clustered index locks. What confuese me...
When we use profiler trace the performance, we find one store procedure requires exclusive table lock. Does this sound right ?
How can I tell whether the application uses COM or not. I am not a application developer, the only thing I know is that the application use ODBC for...
OK, below is the complete code, hope you will not get bored. It is definitely not right, having cursor inside trigger. Yet there is something else...
I just inherit a database. A couple of tables have update/insert triggers on them. Like this: ----------------------------------------- CREATE...
Basically, our application experiences some locking issues. Sometimes, when the trans/sec was almost 0, the SQL just didn't response. I saw a very...
We have a big problems with locks: Avg Lock Requests/sec: 39455.02 Avg Batch Requests/sec 33.70 Avg Latch Waits/sec: 28.4 Avg Workfiles created/sec...
Well, we have a SQL cluster setup as active/passive, W2K + SQL2K (sp3). We need to do some loading test on this box to evaluate its capacity. We...
TABLEB is an Oracle table. we use linked server to pull data through. DELETE FROM TABLEA WHERE not exist (SELECT * FROM TABLEB) = Delete from...
Separate names with a comma.
