Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amgrace
Starting Member
30 Posts |
 Posted - 2004-08-24 : 11:22:10
|
| Hi,From your experience/knowledge of Using SQL server,can you please tell me generally how I can tell whether a problem is software, hardware or data issues.I do not have a specific problem at the moment,Thanks very much.Grace |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-24 : 12:05:05
|
| I'm going to take a stab at this even though I don't have a real clear understanding of what it is you are looking for.hardware problems usually show up with errors in the system event log. Data issues (corruption?) typically will show up in the SQL Error log, it helps to run the DBCC tools frequently to find these errors. Software problems can be anything from issues in the client app, to issues with sprocs at the database to whatever. If you are talking about troubleshooting TSQL software problems (slow SQL, SQL that takes lots of CPU, etc.) then you would use the profiler tool to find this.btw, don't cross post.-ec |
 |
|
|
amgrace
Starting Member
30 Posts |
Posted - 2004-09-06 : 07:47:37
|
| Thanks very much |
|
|
|
|
|
|
How to tell if a problem is DATA, S/WARE or H/WARE