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 |
|
Jaybee from his castle
Yak Posting Veteran
64 Posts |
 Posted - 2004-03-25 : 11:42:09
|
| When you run a stored procedure, is it a given in SQL Server that it will succeed or fail in it's entirety? For example, Procedure X has the function of deleting from a particular row first, then writing to a table in another database. If this procedure were to be unable, for whatever reason, to write to that table, would the deletions made at the beginning of the procedure be reversed?Connectivity - if a user can't connect to a SQL database, what should you check, over and above his SQL Login and User, to determine whether the problem is SQL related?Performance - if users complain of slow performance, what should you check to determine whether the problem is SQL related?Thanks in advance guys,JB> |
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2004-03-25 : 12:45:36
|
quote:
When you run a stored procedure, is it a given in SQL Server that it will succeed or fail in it's entirety? For example, Procedure X has the function of deleting from a particular row first, then writing to a table in another database. If this procedure were to be unable, for whatever reason, to write to that table, would the deletions made at the beginning of the procedure be reversed?
No you will need to wrap any statements that need to be completed together or not at all in a Transaction. By using Begin Tran and Commit Tran. quote:
Connectivity - if a user can't connect to a SQL database, what should you check, over and above his SQL Login and User, to determine whether the problem is SQL related?
This really depends on the error messages you are seeing if you provide some specific examples I'm sure we can help. quote:
Performance - if users complain of slow performance, what should you check to determine whether the problem is SQL related?
I would start by looking for blocking processes within SQL then I would look at PerfMon |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-26 : 09:05:02
|
| quote:--------------------------------------------------------------------------------Connectivity - if a user can't connect to a SQL database, what should you check, over and above his SQL Login and User, to determine whether the problem is SQL related?--------------------------------------------------------------------------------Couple more things, check to make sure they have access to their default database. You can find this by looking at the SQL Server login. If they don't, they won't be able to get in through Query Analyzer because it can't open up the default. Also, If you move from one server to another, it's possible for the SID to be off. This will cause problems because the user won't have the correct SID in the database, which would allow him to login to it.quote:--------------------------------------------------------------------------------Performance - if users complain of slow performance, what should you check to determine whether the problem is SQL related?--------------------------------------------------------------------------------You also need to set up Performance monitor and profiler on the SQL Server to check server performance and whether you have slow running queries, deadlocks, blocking, etc. You can get more information on this by asking, searching the forum for performance monitor and profiler, or by looking on sql-server-performance.comMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
debug2k
Starting Member
18 Posts |
Posted - 2004-03-30 : 05:43:32
|
| Hi,I agree with all pertaining to the Performance and have one more suggestion for the connectivitry...Please check your Client Netwok Utility and check the protocols shud match the protocols configured on ur server.Also check ur ODBC connections and verify that u use correct version and credentials to login in to the server.Regards,Deepak |
|
|
|
|
|
|
|
|
A few generic questions