How view will help in performance and how can i identify tempdb is full

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Test Forum » How view will help in performance and how can...

How view will help in performance and how can i identify tempdb is full

Rate Topic

Display Mode

Topic Options

Author

Message

vaithi.saran846

Posted Thursday, December 29, 2011 10:49 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, December 03, 2012 4:32 AM
Points: 28, Visits: 100

Hi,

what is the main advantage of view.? How view will help in performance. consider i have the some complex select query and i am running that in sql server and it is taking lot of time. In this case if i use view, how it will affect? whether the time taken by select query will reduce?

regards,
vaithilingam.k

Post #1228176

saravanan.ayyasamy

Posted Friday, December 30, 2011 1:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 30, 2011 4:25 AM
Points: 9, Visits: 11

View is mainly used for encapsulation, that is, hiding the complexity. In terms of performance, It will not help you a lot. For that, you need to go with " indexed views "

Post #1228192

ChrisM@home

Posted Friday, December 30, 2011 2:19 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:25 PM
Points: 920, Visits: 3,732

vaithi.saran846 (12/29/2011)

If you're having problems with the performance of a complex query, why not post the query and the actual execution plan? Chances are, folks here will make suggestions to improve performance - and you are very likely to learn something useful too.

^{Low-hanging fruit picker and defender of the moggies}

For better assistance in answering your questions, please read this.

Understanding and using APPLY, (I) and (II) Paul White

Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Post #1228200

vaithi.saran846

Posted Friday, December 30, 2011 2:22 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, December 03, 2012 4:32 AM
Points: 28, Visits: 100

Hi

I got the things about view. But what about the tempdb details. How can i identify whether the tempdb is full or not?

Post #1228202

LutzM

Posted Friday, December 30, 2011 2:44 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731, Visits: 12,131

Are those questions part of an interview?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function

Post #1228212

saravanan.ayyasamy

Posted Friday, December 30, 2011 2:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 30, 2011 4:25 AM
Points: 9, Visits: 11

Hi,
Here you go:

use tempdb
select name,(size*8)/1024 as Current_Size_MB,(max_size*8)/1024 as Total_Size_MB from sys.database_files

Post #1228217

« Prev Topic | Next Topic »

Permissions