Viewing 15 posts - 5,986 through 6,000 (of 19,560 total)
Here is a rewrite of the script to support that.
DECLARE @DatabaseName VARCHAR(128) = 'TrainingDB'
SELECT *
FROM msdb.dbo.backupset a
LEFT OUTER JOIN msdb.dbo.restorehistory rh
ON a.backup_set_id = rh.backup_set_id
WHERE database_name = @DatabaseName
AND [type] = 'D'
AND...
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
July 11, 2012 at 1:49 pm
What's the service account for sqlserver?
This can sometimes have an effect on the output of xp_dirtree.
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
July 11, 2012 at 1:32 pm
congrats
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
July 11, 2012 at 1:14 pm
Is it the ssms process or is it SQL server that keeps doing that?
32 bit or 64 bit?
does it happen when executing code or just with ssms open?
Does the same...
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
July 11, 2012 at 1:05 pm
jasona.work (7/11/2012)
EL Jerry (7/11/2012)
SQLRNNR (7/11/2012)
exploding grapesExploding Gremlins
"El" Jerry.
Mogwai
Gizmo
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
July 11, 2012 at 10:59 am
Lynn Pettis (7/11/2012)
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
July 11, 2012 at 10:26 am
Here's a starting point for you
Select *
From sys.databases
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
July 11, 2012 at 10:24 am
Try something like this:
DECLARE @DatabaseName VARCHAR(128) = 'TrainingDB'
SELECT *
FROM msdb.dbo.backupset a
WHERE database_name = @DatabaseName
AND [type] = 'D'
AND server_name = @@servername
AND NOT EXISTS (SELECT *
FROM msdb.dbo.backupset a
WHERE database_name = @DatabaseName
AND fork_point_lsn...
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
July 11, 2012 at 7:42 am
thanks for the question.
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
July 11, 2012 at 7:20 am
Ray K (7/11/2012)
capn.hector (7/11/2012)
rhythmk (7/10/2012)
capn.hector (7/10/2012)
jasona.work (7/10/2012)
SQLRNNR (7/10/2012)
Cliff Jones (7/10/2012)
crookj (7/10/2012)
Daniel Bowlin (7/10/2012)
rhythmk (7/9/2012)
Possinator (7/9/2012)
SQLRNNR (7/9/2012)
Cliff Jones (7/9/2012)
Ray K (7/9/2012)
Revenant (7/9/2012)
rhythmk (7/9/2012)
Brandie Tarvin (7/9/2012)
Daniel Bowlin (7/9/2012)
HeatwaveHeatstroke
Engine
Piston
V6
V8
HEMI
Barracuda
Fearsome
Foursome
Quartette
Beatles!
Monkees
wiener mobile
Hot Dog
Microwave
Amana
exploding grapes
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
July 11, 2012 at 7:15 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
July 11, 2012 at 7:12 am
CREATE TABLE #FileProp (dbid INT,FILE_ID INT, SpaceUsed DECIMAL(14,2));
GO
EXECUTE sp_msforeachdb 'USE ?; Insert Into #FileProp (dbid,FILE_ID,SpaceUsed)
SELECT database_id,file_id,FILEPROPERTY(name,''SpaceUsed'') from sys.master_files where DB_NAME(database_id) = ''?'''
SELECT DB_NAME(database_id) AS DBName,physical_name,CONVERT(DECIMAL(14,2),size)/128 AS FileSize, growth
,CONVERT(DECIMAL(14,2),max_size)/128 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
July 10, 2012 at 4:29 pm
Please post responses to this thread:
http://www.sqlservercentral.com/Forums/Topic1327819-391-1.aspx
We do not want to get the answers fragmented.
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
July 10, 2012 at 3:58 pm
Post the query that you decided to settle on adapting for your needs. I am assuming that you followed recommendation and actually made changes to queries to adapt rather...
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
July 10, 2012 at 3:56 pm
Confio Ignite is an excellent tool. IMHO - best tool out there for monitoring wait stats.
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
July 10, 2012 at 3:49 pm
Viewing 15 posts - 5,986 through 6,000 (of 19,560 total)