Browse by Tags

• arithabort
• best practice
• blogs
• cache
• compiled
• compression
• dmv
• execute
• high cpu
• impact
• indexed views
• indexes
• joins
• kba
• memory
• performance
• permissions
• profiler
• query
• recompile
• schema
• security
• server state
• sql server
• sysmon
• times
• too many
• tsql
• tuning
• undocumented
• update
• view definition

SQL Server undocumented stored procedure to get information on login mapping name
24 December 07 05:55 AM | SQL Master | 2 Comments   

They say better not to use UNDOCUMENTED stored procedures, which is true in the aspect when any Service Pack or version is released that may not be included and your task might have issues in working out. Similar to this I was going through various methods Read More...

Filed under: sql server, security, stored procedure, best practice, server state, undocumented

Stored Procedures caught me with too many recomplies - way out to avoid it
25 October 07 01:35 AM | SQL Master | 2 Comments   

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still Read More...

Filed under: performance, sql server, indexes, kba, recompile, stored procedure, high cpu, blogs, too many

Need to grant permission to view stored procedure text
10 September 07 01:24 AM | SQL Master | 2 Comments   

If you need to grant permissions to a login that only needs to view stored procedures (contents not just names of SP's). Further you may not want to grant that login with DB_OWNER or DB_DDLADMIN roles within that database, so how to achieve this task? Read More...

Filed under: sql server, security, stored procedure, schema, permissions, execute, view definition, update

Performance Tuning - will I loss the indexing when using derived table?
21 August 07 01:19 AM | SQL Master | 2 Comments   

This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables can Read More...

Filed under: query, stored procedure, joins, indexed views, tuning, performance, sql server

Conditional Failed because the followng SET operations has incorrect settings: 'ARITHABORT'
16 July 07 01:10 AM | SQL Master | 1 Comments   

I got this error when trying to drop and create an index on a table. Create failed for index IX_USER_ID (Microsoft.SQLServer.Smo) Additional Information An exception occured while executing a transact sql statement or batch (Microsoft.SQLServer.ConnectionInfo) Read More...

Filed under: sql server, indexes, stored procedure, compiled, tsql, arithabort

Knowing about performance impact of simple use of procedures
13 July 07 07:42 AM | SQL Master | 1 Comments   

If you ask an experience DBA about the reasons for performance loss then the answer should be straight to look for SQL Server, Operating System and hardware counters for further investigation. Simultaneous access to shared resources causes bottlenecks. Read More...

Filed under: performance, sql server, dmv, stored procedure, compiled, compression, impact

SQL Server 2005: Stored Procedure call activity statistics & execution time
21 June 07 02:56 PM | SQL Master | 1 Comments   

Is it possible to get statistics like how many times a stored procedure is called such as average execution time and how often that procedure is being called. Bascially it is possible to get provided that particular stored procedure is active and plan Read More...

Filed under: performance, cache, memory, stored procedure, times, compiled

SQL Server 2005 high CPU occurrence - why it is?
18 June 07 07:33 AM | SQL Master | 2 Comments   

If a particular query is performing poorly the first thing you would check is relevant indexes, even though having associated indexes against those tables may not help any better to the performance. The next phase you observe is high CPU count from the Read More...

Filed under: performance, profiler, sysmon, recompile, stored procedure