Viewing 15 posts - 10,801 through 10,815 (of 49,552 total)
That memory consumption isn't from the query, it's from the buffer pool, memory in the buffer pool (used to cache data) isn't associated with any particular query because it's used...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2013 at 12:52 am
You mean queries with high workspace memory grants?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 11:24 pm
Simple recovery it might be less if it can run minimally logged, but generally something like this is a size of data operation, so log space needed > data size.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 7:44 am
The index build is using the transaction log. It's a single transaction, the log can't be reused until it completes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 7:14 am
Ed Wagner (11/27/2013)
GilaMonster (11/27/2013)
Anyone want to handle this one?'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'
http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx
I offered up...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 6:26 am
Anyone want to handle this one?
'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'
http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 5:46 am
I guess to answer that one would have to look at the server that's sending you that info and see what it's set up to send, when and how. None...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 5:45 am
MohamedDBA (11/27/2013)
But after I get these certificates what is the name of my job will be ( Senior DBA , or Senior Systems Administrator ... etc )
Depends on the company....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 5:07 am
That's low page density, not fragmentation. When you say 'fragmentation', the general assumption will be that you mean 'logical fragmentation'
The optimiser has no knowledge of logical fragmentation. It has no...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 4:54 am
Define 'internal fragmentation' please? It's not a standard term, it doesn't have a defined meaning, different people use it for different things.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 4:41 am
SQL Show (11/27/2013)
--Now I’m creating one NCI with heavy fragmentationCREATE NONCLUSTERED INDEX [idx_BigTable_SomeColumn1] ON [dbo].[BigTable1] (c2 ASC)
with fillfactor=2
That creates an index with very low fragmentation, not heavy...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 4:28 am
The optimiser has no knowledge of fragmentation, therefore logical fragmentation cannot directly affect an execution plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 4:24 am
Please don't cross post. It just ends up fragmenting replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1517984-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 4:22 am
DBCC ShrinkFile (or ShrinkDatabase) is the only way to release space back to the OS. Depending on what you deleted, you may need to rebuild the clustered index first if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 3:54 am
You can back up the entire database and then delete the older data. You can't take a backup of part of a database unless the database has multiple files or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 3:39 am
Viewing 15 posts - 10,801 through 10,815 (of 49,552 total)