Viewing 15 posts - 1 through 15 (of 50 total)
thanks Ted, it worked for me as well....now to find out who is growing my tempdb 1 AM in the morning to rediculas sizes ..
September 6, 2010 at 6:53 am
I am experiencing the same issue , have you manage to find the problem ?..
August 20, 2009 at 2:12 am
No need to appologize did nothing wrong, I just find that sometimes people look at SQL Server as the little brother and I get very frustrated because of this(not...
April 2, 2009 at 10:55 am
If any one that think's SQL is less complex then Oracle or DB2 then I would assume you have excessive knowledge in these products to make such a decision. Then...
April 2, 2009 at 10:03 am
Great Article, Since most DBA's responsiblity is supporting\troubleshooting such a complex product like SQL server you have highlighted a good methodology and approach to problem solving, Thanks ! 😉
April 2, 2009 at 7:48 am
Please send your results of select * from sys.dm_os_wait_stats
select * from sys.dm_os_wait_stats
where wait_type = 'SOS_SCHEDULER_YIELD'
December 12, 2008 at 5:41 am
I think the reference gives you clear indication as to why you need to do it.
Just picture this ..8 way machine with high workloads and many statements initiating a...
December 3, 2008 at 3:33 am
Yes you can set the cost threshold , but even when you do initiate a degree of parrallelism opertion you do not want to effect all the schedulers and...
December 3, 2008 at 2:36 am
I have a newly build sql server cluster and getting these errors with no application volume at all.
December 3, 2008 at 2:13 am
As a best practise
configure maxdop on half your cores
so if oyu have 8 cores in the server make maxdop 4 or less.
If you have hyperthreaded CPU's...
December 2, 2008 at 4:01 pm
is this just updating data ?...so inserting , deleteing and retrieving is acceptable ?
You will have to find out why SQL is 100% ....
In profiler use your own templete and...
December 2, 2008 at 4:00 pm
another vote for the book.
You could use DTA , but just be carefull to get to familiar with DTA , some people use it because they are to lazy...
December 2, 2008 at 3:16 pm
have you read this?
and here is our beloved PSS engineers response as well
hope this helps
December 2, 2008 at 3:03 pm
Hmmm waittypes and queue's very important to understand and if you do then it is a great performance tuning factor ..
Looking at your list of waittypes it is relatively...
May 14, 2008 at 11:25 am
I agree with Gilamonster (whatever the name is)
Look at the waittypes and waittime while executing the sql statement ..the Optimizer might not even use the non clusterd index and did...
May 13, 2008 at 4:52 pm