Viewing 15 posts - 17,296 through 17,310 (of 19,560 total)
Limitations and performance implications.
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
February 16, 2010 at 10:53 am
varma1412-1092791 (2/16/2010)
Please help me out with the above question. No one answering .
An answer and a resource on how to do it was posted. Is the question different than...
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
February 16, 2010 at 10:40 am
contractors
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
February 16, 2010 at 10:33 am
rambilla4 (2/10/2010)
Did anybody create log shipping & ship the log file to secondary based on fixed size instead of every 5 mins or 15 mins? For example if the log...
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
February 16, 2010 at 10:32 am
I am curious to know if there was any query improvement on the subsequent runs of the query. Are these times the first run of the query?
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
February 16, 2010 at 10:26 am
Then you will need to add odometer reading to the query that Gail provided.
ROW_NUMBER() OVER (PARTITION BY Vehicle.VehicleID ORDER BY Odometer Desc, RPTUTCDATE DESC)...
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
February 16, 2010 at 10:23 am
I think the important thing to note is that the most assured method to know which SQL server is a VM or not, one should coordinate with the SysAdmin team....
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
February 16, 2010 at 10:16 am
You're welcome.
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
February 16, 2010 at 10:09 am
2nd or 3rd time in the last couple of days that I have seen it. It is sometimes easier to just give a reference.
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
February 16, 2010 at 10:04 am
Nice question indeed. Thanks for submitting it.
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
February 16, 2010 at 8:55 am
Robert is correct on this. To control log file size in log-shipping, backup the log more frequently.
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
February 16, 2010 at 12:04 am
Three options were presented for that.
You can check the create date of Tempdb as suggested in the script from Alz
You can check sql error logs
or
You can check Windows Event Log....
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
February 15, 2010 at 11:44 pm
bitbucket-25253 (2/15/2010)
And Steve was off today on a ski trip ... but he did manage to add to the question "SQL Server 2000". but said nothing...
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
February 15, 2010 at 11:36 pm
It could be an indicator of insufficient permissions.
Hopefully you are able to retrieve results. If you can get results, then you have an alternative method to get your perf...
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
February 15, 2010 at 11:32 pm
Thanks Steve.
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
February 15, 2010 at 11:28 pm
Viewing 15 posts - 17,296 through 17,310 (of 19,560 total)