Reputation
534
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 9 27
Impact
~57k people reached

  • 0 posts edited
  • 0 helpful flags
  • 65 votes cast
Jun
10
awarded  Notable Question
May
16
awarded  Popular Question
Apr
5
awarded  Popular Question
Jan
4
comment How can I log the most CPU-Intensive processes in regular intervals?
Great, thanks again! :)
Jan
4
comment How can I log the most CPU-Intensive processes in regular intervals?
Thanks. Just one additional question: The TotalProcessorTime is good for finding general CPU hogs, but for CPU spikes I'd like to see the current CPU usage. Is there any way to get that via Powershell?
Jan
4
accepted How can I log the most CPU-Intensive processes in regular intervals?
Jan
4
comment How can I log the most CPU-Intensive processes in regular intervals?
Thanks a lot! :)
Jan
3
asked How can I log the most CPU-Intensive processes in regular intervals?
Dec
16
awarded  Popular Question
Sep
2
awarded  Notable Question
Jul
9
awarded  Popular Question
Jul
2
awarded  Popular Question
Apr
8
awarded  Popular Question
Mar
2
awarded  Popular Question
Feb
17
awarded  Nice Question
Dec
29
accepted Does SQL Server 2008 R2 Web edition support CSV and XML export?
Dec
29
answered Does SQL Server 2008 R2 Web edition support CSV and XML export?
Dec
12
comment Cannot add witness to my mirroring setup
The next line after the one you quoted restarts the mirroring session.
Dec
10
comment Cannot add witness to my mirroring setup
I think you are confusing this with the "alter database <dbname> set partner <hostname>" command. That one has to be executed on the mirror first, then on the principle. "Set witness" is only initiated on the principal - if you try to run it on the mirror, you get the following error: "Msg 1470, Level 16, State 2, Line 1 The alter database for this partner config values may only be initiated on the current principal server for database MYDBNAME"
Dec
10
comment Cannot add witness to my mirroring setup
I think the reason I did not get any monitoring data from the witness is that it raises less events than the principal and the event types are different as well. Please see my edit 3 above.