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
- 9911 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
How can I create a new template for import ? : sql server management studio
What are transactions and its controls?
how would you store your query in an SSRS report or a Database server?
What are the different SQL Server Versions you have worked on?
What is de-normalization in sql database administration? Give examples?
How can I tell if sql server is 32 or 64 bit?
What is scan table/view and seek table/view when its occurs? : sql server database administration
How to create a simple stored procedure in ms sql server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is faster join or union?
Explain difference between control flow and data flow?
What are commonly used odbc functions in php?
Determine when an index is appropriate?
What is the concept of optimization?
