Viewing 15 posts - 7,231 through 7,245 (of 22,219 total)
If you have the money, you'd better off with more than one disk to stripe the access. Also, for ~600gb of data, 8gb is a shockingly small amount of memory....
"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 13, 2014 at 9:11 pm
TheSQLGuru (11/13/2014)
I will add that you must be on Enterprise (or Developer) Edition of SQL Server to use them at all.
Oh, and that. Thanks.
"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 13, 2014 at 5:12 pm
OK, that's weird. It just worked the second time? Huh... I'm stumped. That error is pretty explicit. It's not possible that someone has been mucking with the server?
"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 13, 2014 at 4:57 pm
GilaMonster (11/13/2014)
g.britton (11/13/2014)
SeanNerd (11/13/2014)
I have a table where we cannot use the typical int identity primary key column. The table can...
"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 13, 2014 at 4:29 pm
A little confused by what's going on. Red Gate (good choice) SQL Compare doesn't do backups and restores. It just compares databases to other databases, backups, scripts, source control, and...
"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 13, 2014 at 3:51 pm
Just make sure you carefully document what you're removing and have it stored somewhere that everyone remembers.
"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 13, 2014 at 3:43 pm
Based on the fact that you're seeing performance increase after FREE_PROCCACHE, while it may be other things, it's more than likely first and foremost, bad parameter sniffing. You need 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 13, 2014 at 3:41 pm
Then that's odd. I can't recreate it. Here's what I did. I opened a session and used this code:
CREATE PROCEDURE dbo.TestingColumns
(@SalesOrderID INT)
AS
SELECT soh.SalesOrderID
FROM Sales.SalesOrderHeader AS soh
WHERE soh.SalesOrderID = @SalesOrderID;
Then...
"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 13, 2014 at 8:10 am
The wide index is less efficient in terms of storage, but in terms of covering, it'll be the same. Either an index has all the columns needed to satisfy 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 13, 2014 at 6:38 am
I'm honestly not sure. It sounds like something was cached at the client of the other session. Recompiling the procedure from the first session would invalidate the execution plan in...
"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 13, 2014 at 6:34 am
At the end of the backup process, any transactions that have completed while the backup was running will be brought into the backup. The recovery step of the restore process...
"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 13, 2014 at 5:46 am
I'd suggest taking a look at the Minion scripts[/url] by the Midnight DBA team. That gives you a lot more control than the maintenance plans.
"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 13, 2014 at 5:44 am
First, the server has to be part of a failover cluster (the service, not the physical set up). Then you go to Configuration Manager to enable availability groups. This 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 13, 2014 at 4:59 am
Think of each database as a service. A given service has a contract that says for these inputs, you get these outputs. With that in mind, any given access mechanism...
"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 13, 2014 at 4:51 am
My query performance tuning book also talks about the dangers of multi-statement table valued user defined functions. The newest one has the most discussion around that.
"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 13, 2014 at 4:48 am
Viewing 15 posts - 7,231 through 7,245 (of 22,219 total)