Can highly fragmented indexes cause CPU spike in SQL Server? -

-

i seeing cpu spikes on database server everyday , found out indexes not rebuilt quite while. reason of spikes?

fragmentation might cause little more cpu load not cause spikes. why it? elsewhere. find out queries running during spikes, , @ long-running queries lots of cpu.


Comments

Post a Comment

Popular posts from this blog

php - Cakephp Not validating data in Form -

-
i trying validate data form(.ctp file) in cakephp 2.3.8. echo $this->form->create('user').'<br />'. $this->form->input('handle', array( 'rule' => 'notempty', 'alphanumeric' => array( 'rule' => 'alphanumeric', 'required' => true, 'message' => 'username must letters , numbers, no special characters' ), 'between' => array( 'rule' => array('between', 4, 8), ...
Read more

java - RSS Feed Parsing, extracting field value -

-
i totally new in rss feed parsing. trying, duration of mp3 file. unable value specific tag <itunes:duration>01:00:00</itunes:duration> here parsing code: public list<rssitem> parse() { final rssitem currentmessage = new rssitem(); rootelement root = new rootelement("rss"); final list<rssitem> messages = new arraylist<rssitem>(); element channel = root.getchild("channel"); element item = channel.getchild(item); item.setendelementlistener(new endelementlistener() { public void end() { messages.add(currentmessage.copy()); } }); item.getchild(title).setendtextelementlistener( new endtextelementlistener() { public void end(string body) { currentmessage.settitle(body); } }); item.getchild(link).setendtextelementlistener( new endtextelementlistener() { public void end...
Read more