Viewing 15 posts - 8,131 through 8,145 (of 22,219 total)
isuckatsql (5/15/2014)
"By the way, just we're clear, dbo.cb is an indexed view? What's the key value on?"dbo.cb is a Table not am Indexed View.
The primary key is ID.
Thanks
Then where are...
"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
May 15, 2014 at 5:44 am
You can get some idea of what's accessing it by querying sys.dm_exec_query_stats and combining that with sys.dm_exec_sql_text and looking for your particular table. But, that's only going to show 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
May 15, 2014 at 4:51 am
And don't use the Profiler gui against a production server. It can add to your problems because it buffers data in a different way than server-side trace.
"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
May 15, 2014 at 4:47 am
Sure, the duration in SSMS includes the time it takes to move the query and the results across the network. Trace and extended events just measure the time it takes...
"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
May 15, 2014 at 4:46 am
mssqlsrv (5/15/2014)
I am doing the rebuild process once only.If I don't drop the views and indexes which are schema bound to table,
Will that affect my insert statements on table?
Yes, it...
"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
May 15, 2014 at 4:34 am
Koen Verbeeck (5/15/2014)
Grant Fritchey (5/14/2014)
... So, if you need to have a mixed access table, ....
What do you mean with this?
The table becomes read-only, so you can access it only...
"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
May 15, 2014 at 4:33 am
I'm a little confused. Let's verify that backups work. Can you run something like this from your T-SQL window in SQL Server Management Studio:
BACKUP DATABASE yourdbname
TO DISK = 'x:\yourdriveandlocation.bak'
WITH INIT,...
"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
May 14, 2014 at 7:22 pm
isuckatsql (5/14/2014)
http://www.statisticsparser.com/Is this good enough?
Ha! Well that is one way to do it I suppose.
You're still dealing with the fact that some of the time you're seeing is just because...
"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
May 14, 2014 at 5:08 pm
Oh, and welcome to SQL Server Central. We try to provide a nice, helpful place around here. If you ever get attitude from anyone, let me 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
May 14, 2014 at 3:39 pm
This web site [/url]does a nice job of summarizing the differences between the two. The big difference is that mirroring actually provides an automated stand by situation where the mirror...
"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
May 14, 2014 at 3:38 pm
The big one for me would be that you can just add a nonclustered columnstore index to the table, but still have the table stored as a regular SQL 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
May 14, 2014 at 3:29 pm
First thing I'd suggest is not trying to do this with stats. It's fine when collecting information for one query. As soon as you start collecting two, three, etc., it...
"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
May 14, 2014 at 3:20 pm
Why are you using common table expressions here? You define this:
WITH results
AS (SELECT id,
...
"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
May 14, 2014 at 12:47 pm
How are you measuring the time? From the SSMS client? That includes the time to transmit across the wires and isn't a good measure of server performance. If you really...
"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
May 14, 2014 at 12:27 pm
I'm assuming you're getting the fragmentation information from sys.dm_db_index_physical_stats. If so, are you using the DETAILED mode to gather your metrics? I've never seen SAMPLED or LIMITED take very much...
"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
May 14, 2014 at 10:50 am
Viewing 15 posts - 8,131 through 8,145 (of 22,219 total)