Viewing 15 posts - 21,946 through 21,960 (of 49,552 total)
The majority of the memory usage is usually the data cache and the plan cache together. The memory used by individual queries is usually tiny in comparison.
Use the sys.dm_os_memory_clerks DMV,...
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
December 2, 2011 at 7:31 am
Ninja's_RGR'us (12/2/2011)
Kidding aside, it's really a great tool for that job.
That's an understatement. I've been using the format option to sort out the mess of code that I'm trying to...
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
December 2, 2011 at 5:52 am
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
December 2, 2011 at 4:51 am
Why? The DMV I mentioned is instance-wide and can give you the page count per table and index. You can use Object_Name with the second parameter to get the table...
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
December 2, 2011 at 3:19 am
Query sys.dm_db_index_physical_stats. There's a column page_count. A page is 8kb.
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
December 2, 2011 at 2:58 am
Elliott Whitlow (12/1/2011)
GilaMonster (12/1/2011)
Elliott Whitlow (12/1/2011)
Ok, then I was basing my perspective on SQL 2000. Good to know.
Even on SQL 2000 the 'pointers' in a nonclustered index are the...
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
December 2, 2011 at 1:16 am
Elliott Whitlow (12/1/2011)
Ok, then I was basing my perspective on SQL 2000. Good to know.
Even on SQL 2000 the 'pointers' in a nonclustered index are the clustered index key...
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
December 1, 2011 at 4:21 pm
brian 20008 (12/1/2011)
I'll have to post the text execution plan later as it'll kill our production server for 5 minutes or so while the query executes.
Not text. The XML plans...
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
December 1, 2011 at 2:36 pm
Execution plans please. Queries too if possible.
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
December 1, 2011 at 2:06 pm
Elliott Whitlow (12/1/2011)
Gila is that correct. If the record moves at all doesn't the pointer change as well?
If a table has a clustered index, the 'pointer' is the key...
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
December 1, 2011 at 2:05 pm
Same results as what? The union? The queries without the union?
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
December 1, 2011 at 1:49 pm
It'll have absolutely no effect on the nonclustered indexes. Nonclustered indexes use the clustered index key as a 'pointer' and that doesn't change in a rebuild.
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
December 1, 2011 at 12:59 pm
Tables, by definition, don't have an order. The only thing that order by on an insert will do is control how identity values are assigned. If you want a resultset...
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
December 1, 2011 at 12:26 pm
Let me guess, it's showing restricted to 2 TB?
2TB is the maximum size a log file can be (refer BoL), hence it's the same as unlimited.
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
December 1, 2011 at 10:41 am
SQLRNNR (12/1/2011)
Slick - definitely moving up higher on the list of software to use.
It's a 130 MB download, an ISO of a bootable CD. I've got a CD with it...
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
December 1, 2011 at 10:18 am
Viewing 15 posts - 21,946 through 21,960 (of 49,552 total)