Viewing 15 posts - 16,696 through 16,710 (of 19,560 total)
Lynn Pettis (3/9/2010)
I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash. 😛
Care to enlighten us?
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 9, 2010 at 1:09 pm
vaibhav.tiwari (3/9/2010)
Out of the above numbers which 6 numbers will make the total 21.
only addition...
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 9, 2010 at 12:53 pm
As Gethyn and Luke have said, I also restart the service with Password change. I normally schedule this kind of change during a maintenance window. This is based...
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 9, 2010 at 12:32 pm
Very interesting. I don't get that kind of result on any of the SQL 2005 or 2008 servers that I tested it against.
Did you change 'YOURDBNAME' to be the...
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 9, 2010 at 12:24 pm
What do you get when you rewrite the select query as follows:
select MachineName, ObjectName, CounterName, Countervalue, TimeRead
from repl_latency_cte
where ObjectValue = 'Memory'
And CounterName = 'Pages Input/sec'
And countervalue > 20
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 9, 2010 at 12:21 pm
I would setup some monitoring to watch the tempdb growth. You need to find what is causing the database to grow like that.
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 9, 2010 at 12:13 pm
ALZDBA (3/9/2010)
- master is a must !
- resource db files .... maybe ... so YES too ! but only once after every install/hotfix/cu/sp
- model ? I...
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 9, 2010 at 12:05 pm
And three for the record. I agree with Lynn and Gail. Backup your system dbs (master, model, msdb). This will save you time and effort should a...
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 9, 2010 at 12:04 pm
pshaship (3/9/2010)
The above script is NOT working as expected. It's displaying only 1 row that to system table info as below:
DBName TableName IndexName ...
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 9, 2010 at 11:55 am
Nice explanation and test setup Oleg.
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 9, 2010 at 10:24 am
Chris Morris-439714 (3/9/2010)
CirquedeSQLeil (3/9/2010)
TwiggyROFLMFAO!!!!!
That was my knickname in school!
I guess that psychic helmet I bought is working correctly then. 😀
Beedeebeedeebeedee
I guess I spelled it wrong - is it Twiggy or...
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 9, 2010 at 10:22 am
I think another tool is the system views,tables and functions. The DMVs in 2005 and beyond can prove quite useful and can provide similar information to PerfMon.
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 9, 2010 at 10:17 am
GSquared (3/9/2010)
GilaMonster (3/8/2010)
CirquedeSQLeil (3/8/2010)
Jason must not be paying attention. I thought George was asking a serious question. (To segue from Gails post.)
I 'complained' about people repeating my posts word...
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 9, 2010 at 9:57 am
Remarkable.
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 9, 2010 at 9:57 am
I think you missed the point.
If the jobs are going from the US to India, then why move away from the jobs? If you are in India and all...
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 9, 2010 at 9:44 am
Viewing 15 posts - 16,696 through 16,710 (of 19,560 total)