Viewing 15 posts - 5,086 through 5,100 (of 49,552 total)
alessandro.feltrin (8/7/2015)
GODBCC SHRINKFILE (N'ARSystem_log' , 0, TRUNCATEONLY)
GO
Does this sounds better than before?
No. Your previous script was correct with the amendments I made. Replace the first parameter with 2 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
August 7, 2015 at 11:22 am
Grant Fritchey (8/7/2015)
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
August 7, 2015 at 6:43 am
You don't need to switch it to simple, and the two options (reorganise or release unused space) are only for shrinking data files.
The command you have there is almost right....
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
August 7, 2015 at 6:38 am
All GO does is tell SSMS where to break the batches of commands that it sends to SQL Server. Nothing else.
Think of it the same as using two windows 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
August 6, 2015 at 1:22 pm
GO is not a T-SQL keyword. It's an SSMS batch breaker. It delimits the batches sent to SQL Server. Since the CREATE procedure has to be in a batch by...
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
August 6, 2015 at 12:35 pm
Grant, who works for Redgate, recommends distributed replay. 🙂
Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use SQLMonitor...
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
August 6, 2015 at 6:55 am
JaybeeSQL (8/6/2015)
Does Distributed Replay work similarly?
Yes, you can use multiple controllers (from multiple client machines) to scale the workload up. You can use the Stress option of distributed replay as...
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
August 6, 2015 at 4:39 am
I generally recommend that system DBs (master and MSDB) never be restored across instances or servers, even if it works, the chance of lingering problems is far too high. Especially...
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
August 6, 2015 at 4:27 am
GilaMonster (8/6/2015)
Run the following, post the full and complete, unedited output.
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
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
August 6, 2015 at 4:24 am
It does a consistency check of the database.
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
August 6, 2015 at 4:11 am
Then you have a serious problem.
Run the following, post the full and complete, unedited output.
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
Do not do anything else to the database.
You may want 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
August 6, 2015 at 12:50 am
Yes, because that generates just one ALTER.
Easier way, remove the variable and just have the commands printed to screen, then copy, paste into new query window and run all
SELECT 'ALTER...
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
August 6, 2015 at 12:33 am
Restore from your last good backup (backup before the corruption happened)
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
August 6, 2015 at 12:29 am
It's not usually a linear progression. I did a scale-up test for a client last year. As load increased, the CPU increased linearly up to about 2.5x base load, at...
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
August 5, 2015 at 1:37 pm
jasona.work (8/5/2015)
On a side note, anyone want my summer cold? I'll even drive to your house and deliver it in person...
Would you accept winter flu in exchange?
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
August 5, 2015 at 1:06 pm
Viewing 15 posts - 5,086 through 5,100 (of 49,552 total)