No announcements
Found 1563876 threads
-
0 VotesBest CPU to run a Website on that relies heavily on database activity?
I want to upgrade my CPU so that I have a computer that is comfortably capable of handling a Website that relies heavily on SQL Server database ...Answered | 1 Replies | 7463 Views | Created by BradleyA - Tuesday, January 18, 2011 11:54 PM | Last reply by Shrikant Maske - Wednesday, January 19, 2011 12:30 AM
-
0 Votes
Best CPU to run a Website on that relies heavily on database activity?
But more about what generic features to look for when looking for a good motherboard and CPU combination to run a web server on.Answered | 5 Replies | 4947 Views | Created by BradleyA - Wednesday, January 19, 2011 3:39 AM | Last reply by Andre.Ziegler - Wednesday, January 19, 2011 4:16 PM -
0 Votes
generate an email alert if the memory/CPU gets heavily utilized
CPU utilization alerts are little bit tricky because I think that you don't want to be alerted for every CPU peak.Answered | 13 Replies | 3368 Views | Created by Eben Raja Earnest - Wednesday, January 4, 2012 7:38 AM | Last reply by Harsh Chawla - Wednesday, January 4, 2012 12:22 PM -
0 Votes
SQL Server CPU through activity monitor
I would not recommend you looking at Activity ...Answered | 3 Replies | 1212 Views | Created by KanishkaBasak - Friday, June 9, 2017 2:12 PM | Last reply by Uri Dimant - Monday, June 12, 2017 12:31 PM -
7 Votes
microsoft.exchange.search.exsearch.exe running high CPU
The indexer service had been running at around 50% CPU utilization for a few days (and this is a small site).Answered | 18 Replies | 53213 Views | Created by jayIT8 - Monday, January 31, 2011 4:29 PM | Last reply by Bastian_W - Wednesday, November 9, 2016 12:43 PM -
0 Votes
Effective GUI for monitoring blocks, memory, cpu,io in SQL server
Use (free) SSMS built-in tools: Activity Monitor, Server Reports, Database Reports.Answered | 4 Replies | 1545 Views | Created by Preetha7 - Tuesday, April 22, 2014 6:48 AM | Last reply by Kalman Toth - Wednesday, April 23, 2014 12:53 AM -
0 Votes
SQL Server -- No Databases but Consuming CPU
Hi If you have nothing running on the server it's likely to be system processes.Answered | 1 Replies | 2017 Views | Created by Trecius - Thursday, May 14, 2015 10:34 PM | Last reply by jmcmullen - Thursday, May 14, 2015 11:47 PM -
1 Votes
One database using most of the CPU
I ran a query to find out which database was using most of the CPU.Answered | 5 Replies | 1125 Views | Created by frederixx - Wednesday, January 8, 2014 3:16 PM | Last reply by Shanky_621 - Thursday, January 9, 2014 8:19 AM -
0 Votes
CPU yo-yoing on Database server
It is common for CPU, disk I/O, etc. to vary during normal activity.Answered | 3 Replies | 926 Views | Created by runnerpaul - Friday, February 6, 2015 12:27 PM | Last reply by Alberto Morillo - Friday, February 6, 2015 2:24 PM -
0 Votes
Slow running query on heavily updating table
Please don't advise NOLOCK on forum where we have no or minimal information about OP database and infrastructure.Answered | 4 Replies | 1070 Views | Created by GaneshAgrawal - Thursday, February 5, 2015 10:20 AM | Last reply by Shanky_621 - Thursday, February 5, 2015 1:50 PM -
1 Votes
track the user activities on a database ?
Thanks Jason for your reply. can you please let me know what are the events i have to add to get the users (2 or more) activities with sql text.Answered | 8 Replies | 6014 Views | Created by rupc - Wednesday, April 6, 2016 3:13 AM | Last reply by rupc - Tuesday, April 12, 2016 9:39 AM -
0 Votes
Azure website consuming enormous CPU time
It can take time for IIS to start or wake the website, start the w3wp process, and etc.Answered | 3 Replies | 3766 Views | Created by K.Kong - Wednesday, August 7, 2013 4:03 PM | Last reply by vishalishere - Thursday, August 8, 2013 5:22 PM -
0 Votes
Biztalk Database CPU 100%
First double check what process is causing the server to max out the CPU.Answered | 2 Replies | 1798 Views | Created by noozan - Friday, February 2, 2018 10:50 AM | Last reply by Alastair Grant - Wednesday, February 7, 2018 10:10 PM -
4 Votes
limit CPU and RAM for Database
It is not possible in percentage but if you have more than 1 CPU you can limit the particular instance to use the limited number of CPUs.Answered | 8 Replies | 21109 Views | Created by Jean M - Tuesday, January 31, 2012 10:04 PM | Last reply by Vikram Gopalan - Friday, August 31, 2012 4:39 PM -
0 Votes
Database wise CPU usage and Index fragmention Checking
1 and min(t1.request_id) = max(t1.request_id)); -- Requests running in parallel: select ...Answered | 1 Replies | 7192 Views | Created by SNIVAS - Monday, March 7, 2011 5:36 PM | Last reply by Uri Dimant - Tuesday, March 8, 2011 6:50 AM -
0 Votes
SBS 2011 CPU running at 100%
Hi, According to your description, my understanding is that SBS 2011(virtual machine running on Hyper-V server 2012 R2) CPU is ...Answered | 3 Replies | 1893 Views | Created by ewh_GO - Saturday, November 14, 2015 1:06 AM | Last reply by Eve Wang - Wednesday, November 18, 2015 3:36 AM -
2 Votes
Best Practice Highly Transactional Database
Consider the option to move data during low-activity time (if you don't need data to be available in another database immediately).Answered | 2 Replies | 5388 Views | Created by StanChat - Tuesday, May 22, 2012 12:18 PM | Last reply by Dmitri Korotkevitch - Tuesday, May 22, 2012 7:59 PM -
0 Votes
How to activate office 2003 on new CPU after second CPU died
It cannot be transferred, and the activation system will almost certainly consider a new CPU as a transfer rather than as an upgrade of the current system.Answered | 2 Replies | 3782 Views | Created by one_question - Friday, May 25, 2012 9:05 PM | Last reply by Rohn007 - Saturday, July 7, 2012 6:08 PM -
0 Votes
Unable to take a Database Offline CPU at 100%
I had a similar problem where erroneous code was sending 30000 (two sp's) requests a minute and making cpu run at 100%.Answered | 7 Replies | 2003 Views | Created by dOEPain - Thursday, March 14, 2013 1:04 PM | Last reply by Satish Kumar Gajula - Thursday, March 14, 2013 5:12 PM -
1 Votes
Identify CPU intensive queries currently running
Reference articles: How to find CPU intensive queries SQL SERVER – SSMS: Top Queries by CPU and ...Answered | 1 Replies | 4509 Views | Created by MS_Prog - Wednesday, August 31, 2016 12:59 AM | Last reply by Kalman Toth - Wednesday, August 31, 2016 1:21 AM - Items 1 to 20 of 1563876 Next ›
No announcements
