Viewing 15 posts - 1 through 15 (of 35 total)
It's the base ID and I won't risk try killing it. Not sure if it can be killed except bouncing SQL engine.
If the process is there then there should not...
August 3, 2011 at 12:27 am
select distinct req_transactionUOW from sys.syslockinfo where req_spid = 53
kill 'UOW' <-- The distinct UOW's except all 0's.
August 3, 2011 at 12:09 am
CXPACKET waits are mostly due to parallelism. What is the max degree of parallelism for the server? Is there any hint (MAXDOP) for the queries which are causing the waits?
Check...
August 2, 2011 at 11:35 pm
Definitely agree with you. I think you have misinterpreted my message. What I was trying to point is that if you have a char(20) field and uniformly storing much shorter...
June 23, 2011 at 11:53 pm
You can see in the plan that it's clearly stating that statistics are missing on columns.
First thing first please do a update stats with full scan on the whole database...
June 23, 2011 at 5:03 am
Please post the ACTUAL EXECUTION PLANS of the queries. In addition, please send the output of the following have a better picture of the server.
sp_configure (With show advanced options on)
xp_msver
Also...
June 23, 2011 at 4:35 am
Are you sure that your evaluating expression is returning NULL?
I tried out the following and yes, I got numeric (13,0) as output.. Please have a look and let know if...
June 23, 2011 at 12:49 am
June 16, 2011 at 5:26 am
If you have a fixed length then you should go for char if variable length then varchar. The name of the data types itself is self explanatory.
When comes to performance,...
June 15, 2011 at 11:39 pm
Hello
Yes, I understand that it's the top CPU queries but it's just 700ms cpu time max. It can very well be only 10% of the total CPU usage.. Unless CPU...
June 15, 2011 at 9:53 pm
Approach:
It seems you have already got the list of SQL Servers in your network using Discovery.
Get the server names in a table.
Loop through the servers and run queries on using...
June 15, 2011 at 9:00 pm
Why do you think this is high CPU? Can you find it in %?
Run this query and it will give you the picture since you last restarted SQL services....
June 15, 2011 at 8:12 pm
The buffer cache hit ratio looks pretty healthy (above 99% avg) but page life expectancy is way too low. This is indicating there must be very high physical reads for...
June 15, 2011 at 10:55 am
I think you are looking for this?
use msdb
go
select backupmediafamily.physical_device_name,restorehistory.restore_date from restorehistory
inner join backupset
on restorehistory.backup_set_id = backupset.backup_set_id
inner join backupmediaset
on backupset.media_set_id = backupmediaset.media_set_id
inner join backupmediafamily
on backupmediaset.media_set_id = backupmediafamily.media_set_id...
June 15, 2011 at 9:25 am
Can you please post the actual execution plan?
If you want to capture all the details including the performance counters then use SQLDiag with perfstats script. A little bit of googling...
June 15, 2011 at 8:46 am
Viewing 15 posts - 1 through 15 (of 35 total)