Viewing 15 posts - 4,351 through 4,365 (of 49,571 total)
Fragmentation in heaps is completely different to indexes. For indexes it's logical fragmentation. Heaps have no logical order, so they only have extent fragmentation.
To be honest, if you have a...
November 5, 2015 at 9:25 am
Grant Fritchey (11/5/2015)
I'd strongly suggest looking at Excel and, maybe even more importantly, PowerBI. the technology is wildly different from what we think.
PowerBI is very pretty, and it's pretty easy...
November 5, 2015 at 9:19 am
river1 (11/5/2015)
If I add an additional transaction log (on other disk) to the database that would devide the i/0 between logs . which would help, correct?
No, it wouldn't.
SQL does not...
November 5, 2015 at 9:18 am
Profiler takes latches to sync the display with the server activity. It'll have minimal impact on a server that's got a light workload. As the workload increases, so Profiler's impact...
November 4, 2015 at 5:24 pm
Jeff Moden (11/4/2015)
ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?Depending on where you run it from and how you run it
Profiler can fill up the local...
November 4, 2015 at 4:35 pm
Yes, your use of profiler GUI was the culprit.
NEVER use the Profiler GUI against a production server. It will degrade performance, potentially severely, it can crash the server. Use a...
November 4, 2015 at 4:32 pm
yb751 (11/4/2015)
Also as Gail's answer eluded to, it only helps if those tables have an index. If you have any heaps you are out of luck.
No, index usage stats...
November 4, 2015 at 1:44 pm
That's not automatic stats update, that's a manual update job. If you're seeing that every 20 minutes, then you have a SQL Agent job that's scheduled to run every 20...
November 4, 2015 at 12:31 pm
Yes and no.
You can use the DMV sys.dm_db_index_usage_stats, however that only has data back to the last time SQL Server started
November 4, 2015 at 11:19 am
Consider querying the system tables - sys.partitions or sys.dm_db_partition_stats.
November 4, 2015 at 11:13 am
Always set max server memory. It's not the VMWare admin's job, it's the DBA's job, it's changed in SQL's server settings.
November 4, 2015 at 11:12 am
No. Not unless you selected the option to save to table and specified the TempDB database
November 4, 2015 at 10:41 am
You change it at the server level, availability groups are at the database level, they don't transfer server settings. Change it on all servers, it might not be set to...
November 4, 2015 at 10:34 am
Compatibility level affects how the parser, query optimiser and query processor treat some T-SQL constructs (ones that have changed across the versions). It doesn't change the database version, that's defined...
November 4, 2015 at 10:27 am
Viewing 15 posts - 4,351 through 4,365 (of 49,571 total)