Check the server before go to Production | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Check the server before go to Production

There is any tool to check the server before go to production,
ex;
Install a brand new version of sql 2000 and before move the databases check it if everything it’s ok there is anything like that out there? thanks
By checking what you wants to do ? do wants to perform hardware config check ?! or db itself ? dbcc checkdb
dbcc checkalloc
for existing db’s checking against any error and then if you wants to check hardware their’s tool ‘PC Doctor’ to check hardware but would you please describe in brief what check you wants to perform ? Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

quote:Originally posted by NelsonVig There is any tool to check the server before go to production,

Can you please explain what do you want to check.
is it Hardware resources ? —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

If no hardware problem, after SQL installation check Event Viewer and SQL logs.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Are you wanting to load test the server, check configuration, what? I have the same question dineshasanka has. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
OK in terms of refer the SQL error logs and event viewer logs to ensure no issues that are affecting the application, there is no such tool to check as per your question and if you can be more clear what you’re looking we can help you. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
My Boss want to check everything, hardware and software,
He is asking to strees the server before it go alive..
any ideas?
Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by NelsonVig</i><br /><br />My Boss want to check everything, hardware and software,<br />He is asking to strees the server before it go alive..<br />any ideas?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Hi,<br />please have a look at <br /><br /> <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2761&SearchTerms=hardwareupgrade>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2761&SearchTerms=hardwareupgrade</a><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Check thsihttp://www.microsoft.com/downloads/…53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en free tool link from MS.
quote:Originally posted by NelsonVig My Boss want to check everything, hardware and software,
He is asking to strees the server before it go alive..
any ideas?

Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
quote:Originally posted by NelsonVig My Boss want to check everything, hardware and software,
He is asking to strees the server before it go alive..
any ideas?
See if this helps:http://www.quest.com/benchmark_factory/index.asp
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

It’s not stress-testing but; Run MBSA and show them just how weak the servers are before they put them into production.
]]>