Viewing 15 posts - 10,111 through 10,125 (of 49,552 total)
What exactly do you mean by 'hanged'? What is happening? What are the exact error messages you're getting (if any)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2014 at 2:42 pm
Evil Kraig F (2/4/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2014 at 7:50 am
Ed Wagner (2/4/2014)
GilaMonster (2/3/2014)
Jeff Moden (2/3/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2014 at 5:37 am
Viewing 15 posts - 10,111 through 10,125 (of 49,552 total)