March 11, 2010 at 1:29 pm
I ran the profiler and got the trace file......I then used DTA to analyze the trace file....but i m getting an error message from DTA.....
Here are the five steps involved in the tuning
Action -------------------------------------Status----------------------------------Message
Submitting Configuration Information---------Success------------------------------
Consuming Workload------------------------Error-----------------------------------Partitions are not supported
Performing Analysis---------------------------Stopped-----------------------------------
Generating Reports---------------------------Stopped------------------------------------
Generating Recommendations------------------Stopped----------------------------------------
Why does my second steps failed??? Which Partitions are not supported???
Your help is highly appreciated
Regards,
Sandeep
March 11, 2010 at 9:16 pm
This is referring to partitioned tables. You may need to select the partitioning options in DTA.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 10:17 am
Hey......Thanks for the reply......I have selected Full partitioning option(from Partitioning stratergy to employ Menu) but it shows the same error
Regards,
Sandeep
March 12, 2010 at 10:42 am
Does it provide you with any other error? An error code or more detailed error-text would be very useful.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 10:51 am
It worked if i select No Partitions
Regards,
Sandeep
March 12, 2010 at 11:25 am
Thanks for the support till now.....I have a small question
I ran the Database Engine Tuning Advisor and in my Tuning Log file it says
Category ID __Event_____________________Statement___________Frequency____Reason
S001 xyz Stored proc end else begin set @relationcria=" 1 Statement does not reference any tables
What does it mean Statement does not reference any tables?
Regards,
Sandeep
March 12, 2010 at 11:39 am
That means that the particular statement being referenced / evaluated from the stored proc does not reference any database tables. If there is a section of code that does not pull information from a table - then there is no sense in trying to index it (you can't).
These are informational messages.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 12, 2010 at 11:39 am
sandip.vs (3/12/2010)
It worked if i select No PartitionsRegards,
Sandeep
Good to hear.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply