Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,461 through 14,475 (of 59,101 total)

RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

p.s. To save you some time, I've attached a file called "PerfMon.txt". After you upload it, change the name to "PerfMon.msc" and save it to the desktop of your server...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 9:51 pm

#1957947
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Saturday, September 2, 2017 1:40 PM
Jeff Moden - Saturday, September 2, 2017 11:10 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 9:21 pm

#1957945
RE: Database Development Made Easy?

Heh... I have a saying about designing databases... "If you think it was easy, you did something wrong". There are a lot of "standard" and "best practice" things that must...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 12:48 pm

#1957936
RE: Are the posted questions getting worse?

Neil Burton - Friday, September 1, 2017 8:10 AM
Beatrix Kiddo - Friday, September 1, 2017 7:44 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 12:12 pm

#1957933
RE: Are the posted questions getting worse?

GilaMonster - Saturday, September 2, 2017 12:55 AM
Steve Jones - SSC Editor - Friday, September 1, 2017...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 12:03 pm

#1957932
RE: Database Development Made Easy?

miapjp - Friday, September 1, 2017 4:07 PM
Back a few years ago, we had very OO developers, who'd never seen a stored...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 12:01 pm

#1957931
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Saturday, September 2, 2017 11:27 AM
Hi Jeff & Chris. From the query posted by Chris, we noticed that there is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 11:55 am

#1957930
RE: date fillers - dates in two rows

ekant_alone - Friday, September 1, 2017 7:52 AM
Brilliant! Wow!! wowwww! Jason, Steve, Drew, and Jeff - THANK YOU ALL........ I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 11:45 am

#1957929
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

Eirikur Eiriksson - Saturday, September 2, 2017 3:38 AM
muhammadaftab25 - Saturday, September 2, 2017 12:01 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 11:30 am

#1957927
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

p.s. CPU usage and Duration in the output of sp_WhatsRunning is in decimal seconds, just to make life a little easier. It also identifies if any blocking is going on,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 11:12 am

#1957925
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Saturday, September 2, 2017 12:01 AM
Jeff Moden - Friday, September 1, 2017 9:00 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 2, 2017 at 11:10 am

#1957924
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

Hold the phone a minute... the original post says that the problem occurs every 5-6 minutes. I've found that wait stats are normally a symptom rather than a cause. Someone...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 1, 2017 at 9:00 am

#1957846
RE: date fillers - dates in two rows

Jason A. Long - Thursday, August 31, 2017 9:36 PM
Jeff Moden - Thursday, August 31, 2017 8:33...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 1, 2017 at 8:19 am

#1957841
RE: date fillers - dates in two rows

drew.allen - Thursday, August 31, 2017 10:02 AM
First, sample data should be provided as an INSERT statement into your sample table.
The solution...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 1, 2017 at 8:15 am

#1957840
RE: date fillers - dates in two rows

ekant_alone - Friday, September 1, 2017 7:52 AM
Brilliant! Wow!! wowwww! Jason, Steve, Drew, and Jeff - THANK YOU ALL........ I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 1, 2017 at 8:10 am

#1957837

Viewing 15 posts - 14,461 through 14,475 (of 59,101 total)