Viewing 15 posts - 421 through 435 (of 1,129 total)
Lynn Pettis (7/26/2012)
July 26, 2012 at 3:47 pm
opc.three (7/3/2012)
Lowell (7/3/2012)
--database name required
SELECT *
INTO #tmp
FROM...
July 3, 2012 at 1:06 pm
Steve Jones - SSC Editor (7/3/2012)
July 3, 2012 at 10:47 am
opc.three (6/14/2012)
This may help answer your question:http://stackoverflow.com/questions/28952/cpu-utilization-by-database
Thanks. Does it matter what is my mAXDOP?
June 15, 2012 at 8:52 am
Nikhil Shikarkhane (10/3/2008)
No. Total_worker_time is nothing but CPU count. No need to divide. Its the amount of CPU your process used thats it.
Does it matter if my MAX DOP is...
June 14, 2012 at 12:49 pm
my sincere apologies , after tracking back to the code( i didnt write this) i figured that the values are actual differential's from the baseline. Thanks.
June 12, 2012 at 11:06 pm
matt.newman (6/11/2012)
June 11, 2012 at 10:45 pm
Any idea?
June 11, 2012 at 3:24 pm
GilaMonster (6/8/2012)
sqldba_newbie (6/8/2012)
GilaMonster (6/8/2012)
Autoclose enabled?Database restored?
DAtabase taken offline?
Database detached and attached?
Autoclose enabled? Not sure what this is
The database setting autoclose.
Wow , good to know , never really paid attention at...
June 9, 2012 at 1:26 pm
sqldba_newbie (6/8/2012)
GilaMonster (6/8/2012)
Autoclose enabled?Database restored?
DAtabase taken offline?
Database detached and attached?
Autoclose enabled? Not sure what this is
Database restored? Nope
DAtabase taken offline? Nope
Database detached and attached? Nope
By the way this is...
June 8, 2012 at 4:15 pm
GilaMonster (6/8/2012)
Autoclose enabled?Database restored?
DAtabase taken offline?
Database detached and attached?
Autoclose enabled? Not sure what this is
Database restored? Nope
DAtabase taken offline? Nope
Database detached and attached? Nope
June 8, 2012 at 4:14 pm
GilaMonster (2/15/2010)
It's since the last time SQL Server started.
I am in a similar situation. If this is since last server reboot why did number of reads or io_stall_read went down?...
June 8, 2012 at 11:05 am
karthick_pk83 (5/27/2012)
What is Target Server Memory (KB)?http://mssqlwiki.com/2012/05/27/what-is-target-server-memory-kb/
Seems like you haven't gone through this post, please go through this post and you should by then difference between target and total...
May 29, 2012 at 7:34 am
Elizabeth.Block (5/21/2012)
May 21, 2012 at 11:37 am
Viewing 15 posts - 421 through 435 (of 1,129 total)