Viewing 15 posts - 5,371 through 5,385 (of 22,219 total)
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
But PLE is not a measure of performance. It's merely an indication of load and behavior. Having low or wildly variable PLE is not, by itself an indication of a...
"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 6:56 am
GilaMonster (11/17/2015)
You could buy a tool like Red Gate's SQLCompare and SQL DataCompare to sync the data and schema, but it's probably...
"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 6:54 am
The up and coming technology for HA these days is Availability Groups. There are lots of good articles available at Simple-Talk.
"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 6:47 am
I agree with Gail. I just didn't want to be too negative. If you have the MDF file, you can at least attempt an ATTACH. The likelihood is, everything is...
"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 17, 2015 at 6:08 pm
silas.perkins (11/17/2015)
Asking for expert opinion. A very unfortunate event happened. One of our PCs crashed few days ago. That PC had SQL Server 2008 installed. Unfortunately no backup was running...
"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 17, 2015 at 10:25 am
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored procedures.
They sent to...
"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 17, 2015 at 8:40 am
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
I just glanced at the...
"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 12, 2015 at 6:32 am
If you're on 2012, the GUI is really easy. Don't use the Wizard. It's a waste of time and more than a little misleading.
"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 12, 2015 at 4:44 am
Viewing 15 posts - 5,371 through 5,385 (of 22,219 total)