Viewing 15 posts - 7,486 through 7,500 (of 22,219 total)
It could be cumulative from a series of transactions. Is your database in full recovery? If so, are you running log backups? If not, that could be the issue right...
"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
September 8, 2014 at 6:34 am
No disagreements that full backups are easier, but the whole purpose of having the filegroup backup is the situation you're in. As the size and complexity of your database setup...
"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
September 8, 2014 at 4:25 am
I'm going to pile on with Jeff and strongly suggest you grab a couple of books and get the fundamentals more firmly entrenched in your head. Clustered and non-clustered indexes...
"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
September 8, 2014 at 4:22 am
Validate that the two systems are the same in every possible way because even small differences could lead to major performance changes. But, I suspect it's probably related to statistics...
"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
September 6, 2014 at 4:36 am
The best way to do this would be to use extended events. You can add an action to any event to capture the program name. But, that has to be...
"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
September 6, 2014 at 4:33 am
TomThomson (9/5/2014)
cphite (9/5/2014)
jcrawf02 (9/4/2014)
Ed Wagner (9/4/2014)
Koen Verbeeck (9/4/2014)
andrew gothard (9/4/2014)
Gazareth (9/3/2014)
I've just been told: "We don't recommend running SQL commands against the database"Right. May as well go home then!
You know...
"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
September 5, 2014 at 3:43 pm
SQL Swerver (9/5/2014)
Q. is WASD now called MASD?I thought the correct name Windows Azure SQL Database...(behind the times obviously!) 🙂
Nope. The dropped the Windows name from Azure. They don't want...
"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
September 5, 2014 at 8:43 am
You can't go below the initial size, so you'll have to set that initial size lower. Here is an article from Microsoft that discusses most of the details. There's also...
"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
September 5, 2014 at 3:53 am
I did a quick search online and couldn't identify what DCS Service is either.
In general, yes, you can rebuild indexes while the system is in use. You will see some...
"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
September 5, 2014 at 3:49 am
So, Eirikur, if you used DATE instead of DATETIME would that also solve the issue? Just asking. I don't know MySQL from MyElbow.
"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
September 5, 2014 at 3:46 am
Yep, that's a Performance Monitor counter.
Side note, since you're in SQL Server 2012, I strongly suggest you toss Profiler and go with Extended Events. They're much more light weight, there...
"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
September 5, 2014 at 3:44 am
Sean Lange (9/4/2014)
Grant Fritchey (9/4/2014)
Koen Verbeeck (9/4/2014)
Roy Ernest (9/4/2014)
There was not SQL Saturday this year. We will have one during memorial day weekend next year.
Jack, hopefully we...
"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
September 4, 2014 at 2:01 pm
Koen Verbeeck (9/4/2014)
Roy Ernest (9/4/2014)
There was not SQL Saturday this year. We will have one during memorial day weekend next year.
Jack, hopefully we can meet each other...
"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
September 4, 2014 at 1:38 pm
Yep, fn_trace_gettable is the way to do it.
Also, if you're looking at consuming trace data, I'd suggest getting a copy of the RML Utilities. YOu might have to poke ...
"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
September 4, 2014 at 1:30 pm
Anyone have a good answer to this question?
"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
September 4, 2014 at 12:49 pm
Viewing 15 posts - 7,486 through 7,500 (of 22,219 total)