Interested to Buy Any Domain ? << Click Here >> for more details...
What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
- 3 Answers
- 9744 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / john
PERFORMANCE TUNING:
Shortly : The performance tuning is reduce the load of the
database.
stored procedure:
--create a sample performance tuning procedure
CREATE PROCEDURE dbo.spTestDelegator (@query bit) AS
BEGIN
--NOCOUNT is use to reduce the load
--if its off the procedure get (full memory) of execution
SET NOCOUNT ON;
IF @query = 0
EXEC spTestFromAuthors
ELSE
EXEC spTestFromPublishers
GO
CREATE PROCEDURE dbo.spTestFromAuthors AS
SELECT * FROM authors
GO
CREATE PROCEDURE dbo.spTestFromPublishers AS
SELECT * FROM publishers
GO
STEPS:
1.Good code ideas
2.Reduces use more query in same procedure
3.use clear structure of code
4.always done stored procedure is good. because,Transact-Sql
get load of execution
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is merge replication?
What are horizontal and vertical scaling?
What are scalar functions in sql?
what is normalization? : Sql server database administration
how to do partition in sqlserver
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is transactional replication?
Explain steps of normalization?
What is the difference between inner join and equi join?
What stored by the tempdb ? : sql server database administration
What is transaction server consistency?
How to create an index on an existing table in ms sql server?
Why are you getting errors when creating a new odbc dsn?
What is openrowset sql server?
How do you improve the performance of a SQL Azure Database?
