Viewing 15 posts - 10,111 through 10,125 (of 49,571 total)
What exactly do you mean by 'hanged'? What is happening? What are the exact error messages you're getting (if any)?
February 5, 2014 at 2:03 am
ananda.murugesan (2/5/2014)
Query is not a problem also facing any performance issues from user side but CPU always utilize 60 % constantly.
If the query isn't a problem and you don't have...
February 5, 2014 at 2:02 am
sanku.raghuram (2/4/2014)
I see that we had replication between the source and destination servers. Is it like mandatory to remove the replication and then setup transactional logshipping for sqlserver 2008 R2.
No,...
February 5, 2014 at 12:43 am
Evil Kraig F (2/4/2014)
I would like to ask, if I try to follow SQL Server DBA path, getting MCSA SQL Sever 2012 certification in a year from now:
MCSA? It's...
February 5, 2014 at 12:39 am
The Stats_date() function and the sys.dm_db_index_physical_stats DMV respectively. There are lots of scripts, a google search should dig up a pile.
February 5, 2014 at 12:32 am
Is this query really a problem?
9ms of CPU time to compile isn't large and the cost % alone is pretty meaningless, the costs have to add to 100% over...
February 5, 2014 at 12:31 am
Evil Kraig F (2/4/2014)
I didn't realize SQL worked that closely with the OS.
Standard Windows API call that any app can use. http://msdn.microsoft.com/en-us/library/windows/desktop/aa365469%28v=vs.85%29.aspx
February 4, 2014 at 2:42 pm
Evil Kraig F (2/4/2014)
February 4, 2014 at 2:05 pm
Depends, Start by investigating what they do and determine whether that CPU usage is a problem or not.
Chapters 1 and 3 of https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ should get you started.
February 4, 2014 at 10:59 am
Evil Kraig F (2/4/2014)
My personal concern with that article is bits and pieces like this:
Unlike heap tables, clustered indexes are “living creatures” that move rows around as needed to maintain...
February 4, 2014 at 10:58 am
Yup, that's how system processes run, they're in a permanent run/wait/run/wait cycle from the time an instance starts until it is stopped. If you look, all the system processes will...
February 4, 2014 at 10:46 am
lisa.randles (2/4/2014)
Hi, KeithRight you are. I was under a mis-conception that structure changes did not cause an automatic recompile. However, we also frequently add new indexes....
I...
February 4, 2014 at 8:06 am
Grace09 (2/4/2014)
So there is nothing I should do?
Why do you think you need to do something?
What led you to the conclusion that it has been actively running non-stop since the...
February 4, 2014 at 8:03 am
MickyD (2/4/2014)
Is there any way I can detect a date when corruption occurred , in order to get the latest non corrupted database backup back from the tape vendors ?
It...
February 4, 2014 at 7:50 am
Ed Wagner (2/4/2014)
GilaMonster (2/3/2014)
Jeff Moden (2/3/2014)
February 4, 2014 at 5:37 am
Viewing 15 posts - 10,111 through 10,125 (of 49,571 total)