Viewing 15 posts - 4,891 through 4,905 (of 19,560 total)
Yes it will. That is another day when you need to be proactive.
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, 2013 at 11:58 am
RVO (3/12/2013)
Some more clarification.
Looks like it's a problem with this particular table.
I did [SELECT TOP 30,000 * FROM ism_secmaster_price] which is located in the same database,...
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, 2013 at 11:40 am
Lowell (3/12/2013)
i also have 4 instances on my developer machine, for versions 2005 thru 2012.
when selecting the memory counters in Perfmon, i see instances for 2008,...
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, 2013 at 11:00 am
You will see various job failures like this when the system clock moves forward an hour. As Lynn said, be ready for the time change and adjust jobs as...
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, 2013 at 10:22 am
Here is a quick query to see the internal "point in time" memory clerk use for the sql instance
SELECT @@servername AS InstanceName,SUM(single_pages_kb)/1024 AS [SPA Mem, Mb]
FROM sys.dm_os_memory_clerks
ORDER BY [SPA Mem,...
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, 2013 at 10:12 am
No. You cannot prevent sa from accessing the databases through permissions.
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, 2013 at 9:24 am
JAZZ Master (3/12/2013)
opc.three (3/12/2013)
Stuart Davies (3/12/2013)
SQLRNNR (3/11/2013)
crookj (3/11/2013)
SQLRNNR (3/9/2013)
john.arnott (3/8/2013)
Revenant (3/8/2013)
SQLRNNR (3/8/2013)
opc.three (3/8/2013)
JAZZ Master (3/8/2013)
crookj (3/8/2013)
SQLRNNR (3/7/2013)
crookj (3/7/2013)
Daniel Bowlin (3/7/2013)
HelpSupport
Truss
Tether
Tie
Bolo
Whip
Rawhide
Eastwood
West Side
Story
TOY
(to) infinity
Bed, Bath...
& Body
Works
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, 2013 at 9:20 am
Stefan Krzywicki (3/12/2013)
SQLRNNR (3/12/2013)
Stefan Krzywicki (3/11/2013)
wolfkillj (3/11/2013)
Jeff Moden (3/10/2013)
Stefan Krzywicki (3/9/2013)
Jeff Moden (3/8/2013)
Matt Miller (#4) (3/8/2013)
Jeff Moden (3/7/2013)
Revenant (3/4/2013)
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
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, 2013 at 9:18 am
Stefan Krzywicki (3/11/2013)
wolfkillj (3/11/2013)
Jeff Moden (3/10/2013)
Stefan Krzywicki (3/9/2013)
Jeff Moden (3/8/2013)
Matt Miller (#4) (3/8/2013)
Jeff Moden (3/7/2013)
Revenant (3/4/2013)
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
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, 2013 at 9:06 am
Where have all the crickets gone?
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, 2013 at 8:41 am
m.rajesh.uk (3/11/2013)
how to find whether sql agent is having access to that drive or not. i am new and i dont know how to check
Find the name of 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 11, 2013 at 11:05 pm
Glad to hear it is working now.
As has been noted, I'd take a serious look into renaming that database. The database appears to have a space at the end...
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 11, 2013 at 11:03 pm
Nice and EZ
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 11, 2013 at 10:51 pm
Perfmon has counters by the instance. You can load up memory counters by instance in perfmon to track mem usage.
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 11, 2013 at 10:50 pm
Sqlism (3/11/2013)
I mean to say any other driver other than C drive. I specified E drive as example. sorry for the confusion. So can someone conclude 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 11, 2013 at 9:14 pm
Viewing 15 posts - 4,891 through 4,905 (of 19,560 total)