Viewing 15 posts - 2,416 through 2,430 (of 49,552 total)
As in, at the OS level check and make sure that the SQL Server executable is the process using that 50% CPU.
Have you done that?
Is SQLServr.exe the process using...
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
September 12, 2016 at 9:32 am
Start with the obvious. Is it SQL Server using the CPU?
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
September 12, 2016 at 9:27 am
LaVerne Sanders (9/12/2016)
Just one more question. My SQL 2008rs is still on service pack 1. Should it be SP2 before I start this process? Thanks.
If you plan an...
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
September 12, 2016 at 8:42 am
jpandrade (9/12/2016)
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
September 12, 2016 at 8:41 am
No, and this is not a SQL Server error. It's an error from the client tool, Management Studio. Management Studio's a 32 bit app, so 4 GB memory limit, 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
September 12, 2016 at 8:15 am
The upgrade advisor part does, you should still run upgrade advisor and fix anything that breaks, and you absolutely MUST do performance tests on SQL 2016 due to the changes...
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
September 12, 2016 at 7:39 am
Molap (9/27/2013)
Copy the backup to SQL2012
Restore the database with recovery (I can not restore with standby because it needs to go through an upgrade to 2012)
Backup 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
September 12, 2016 at 7:20 am
Sure. Google "Sys.dm_db_index_physical_stats", the MSDN documentation page will give you full details of what it returns and what parameters it takes.
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
September 12, 2016 at 3:56 am
Maintenance, yes. Maintenance plans, not so much. Don't use them for index maintenance (they're stupid)
Look up Ola Hallengren's maintenance scripts: http://ola.hallengren.com/
You should have backups (don't forget to clean up old...
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
September 12, 2016 at 3:37 am
rodjkidd (9/12/2016)
Gail, how goes your marathon of presenting at SQL Sats? Have you done them all or do you still have one left?
Two down, one to go (and a seminar...
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
September 12, 2016 at 3:31 am
Yup, you have to set the next filegroup to be used after each split, even if all the partitions are going to the same filegroup.
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
September 12, 2016 at 3:28 am
JoeS 3024 (9/10/2016)
Is it still recommended to change the recovery model to Simple?
It's never been recommended to switch to simple to shrink the log, and if you do that...
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
September 11, 2016 at 1:16 am
Hints apply to the whole query, so recompile, if you need it, would go at the end of the outer query. You can also consider OPTION(OPTIMIZE FOR ...)
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
September 11, 2016 at 12:48 am
Install x64.
The x86 is legacy and there's no good reason to use it any longer. SQL 2016 doesn't even have a x86 version.
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
September 10, 2016 at 2:53 am
There's no guarantee that books will come out. Depends on the publishers, whether they find authors willing to write to the tight deadlines and low payments that exam study books...
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
September 9, 2016 at 3:24 pm
Viewing 15 posts - 2,416 through 2,430 (of 49,552 total)