Viewing 15 posts - 5,371 through 5,385 (of 22,227 total)
Nice!
Good job and congrats.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2015 at 11:19 pm
If you could post the execution plan, that would be a big help.
You do realize that NOLOCK could lead to missing or duplicate rows.
Nothing jumps out of the query as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2015 at 11:17 pm
WhiteLotus (11/29/2015)
It will still be my concern because memory is very high ( 96%)Then how do I solve that issue and slowness as well ?
That memory is not an issue....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2015 at 11:07 pm
There is an older book available from Redgate called The Guide to SQL Server Team Development[/url]. It's free to download. It has a chapter on coding standards. The rest of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2015 at 11:02 pm
So other people who will find this in the future and read it know, how did you solve the problem?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2015 at 10:43 pm
benjamin.reyes (11/23/2015)
Grant Fritchey (11/23/2015)
If you do know that the batch...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 24, 2015 at 12:14 pm
I'm pretty much with Gail. Just because it says it's using 98% of memory doesn't mean there's anything approaching a problem.
If you do know that the batch is a problem,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 23, 2015 at 7:20 am
So it's a giant batch process. You could try breaking up the batch into smaller pieces. It might run longer overall that way, but it'll use fewer resources while it's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2015 at 9:54 am
rameelster (11/20/2015)
Since I have allocated 98 percent of memory for Sql server.Could it be the reason I am getting page_io_Latchesfrequently
IO Latches are about reading and writing to disk. It's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 20, 2015 at 7:26 am
Brandie Tarvin (11/20/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 20, 2015 at 6:29 am
GilaMonster (11/19/2015)
Phil Parkin (11/19/2015)
The caveat to this is that if someone created the DB and specified upon creation that the file extensions should be .sql instead of mdf/ndf/ldf
Shudder.
I once...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2015 at 7:35 am
Hard to say for sure without a lot more detail, but it looks like you have a server with some memory stress which is leading to timeouts with your Availability...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2015 at 7:31 am
Except in the case of the OUTER JOIN as the other posters have outlined, there is no fundamental difference under normal circumstances. For the sake of clarity, I would advocate...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2015 at 7:30 am
shamshad.ali (11/18/2015)
CREATE TABLE [dbo].[RTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Amount] [int] NULL,
[DateRange] [date] NULL,
CONSTRAINT [PK_RTable] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2015 at 7:04 am
Adi Cohn-120898 (11/18/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2015 at 7:02 am
Viewing 15 posts - 5,371 through 5,385 (of 22,227 total)